To pivot fields in an Informix MetaCube Cross-Tab report

This tutorial is based on the report created in the tutorial on how to add a field to an Informix MetaCube Cross-Tab report. Because of the numerous brands, the report is difficult to work with as far as viewing data or printing. To make it more user friendly, it would be beneficial to switch the fields so that the columns became rows and rows became columns.

1. Click on the top column header "Alden" and drag it so that it is positioned over the row header "Department Stores" and drop it.

   

2. Now take the row header "Department Stores" and drag it so it is positioned over the column header "Year 1996" and drop it.

   

3. To finish, take the "Year 1996" column header and position it over the Alden row header and drop it.