crystalvictim
Programmer
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!
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!