Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

cross-tab: multidimensional sorting

Status
Not open for further replies.

crystalvictim

Programmer
Dec 4, 2002
92
DE
Hi.
Does anybody out there happen to know if it is possible (using either CR8.5 or CR10) to sort both rows AND columns of a cross-tab based not on the header but on the row/column-total ?
I know it can be done for rows via the top-N-assistant but we'd like to have this also for columns.

Here's an example what the result should look like:
row/col C A D B Total
B 5 0 3 1 9
C 2 1 1 2 6
A 0 4 0 0 4
Total 7 5 4 3 19

Note that the totals being calculated are responsible for both row- and column- order (top-down; left-right).

Thanks in advance for your help!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top