Reverse Cross Table command (Layout menu)

 

Once you got the required result inside a Cross Table, you can wish sometimes to pivot the table result. The columns and the rows can be inverted using the command <Layout> <Reverse Cross Table> or by clicking on the corresponding icon in the Cross Table toolbar.

 

image\revcross.gif

 

Example: in the following example displaying quantities sold by product family and year for each area :

 

image\pivotav.gif

 

You can pivot the table to get the following presentation:

 

image\pivotap.gif

 

See also:

Go back to the Cross table wizard Step 3

Refresh the current Data

Abort

Hide detail

Show detail

Default format