| Author |
 Topic  |
|
|
memux
2 Posts |
 Posted - 05/31/2010 : 17:56:52
|
Guys, friends, i have a problem with sorting in the olap report, i can sort by columns, but i dont know how sort in columns and rows at the same time,
Ex:
This is the Olap Report (i have this)
ProdA ProdB ProdC
Customer A 100 20 40
Customer B 80 40 30
Customer C 120 180 140
This is the Olap Report sorting by rows and columns( I want this)
ProdB ProdC ProdA
Customer C 180 140 120
Customer B 40 30 80
Customer A 20 40 100
With the report portal can do that???
Thanks for you helping.
Memux! |
|
|
admin
1637 Posts |
Posted - 06/02/2010 : 03:36:19
|
| It seems that you want to sort Product placed on Columns based on first row (row-measure tupple) value. The only way to this is to pivot the grid. |
 |
|
|
memux
2 Posts |
Posted - 06/02/2010 : 10:46:05
|
ok, only to confirm, the only way to sort is to pivot the grid, or build a new olap report with the new view, Move dimensions on rows to columns and those on columns to rows. or click the button is switch axis.
The Help in RP says Pivot = Move dimensions on rows to columns and those on columns to rows.
I'm right?
Thanks
Memux! |
|
|
|
admin
1637 Posts |
Posted - 06/03/2010 : 06:35:22
|
| Yes, the only way to sort column members based on a row is to switch axis. |
|
|
| |
Topic |
|
|
|
Report Portal
Ordering of rows and columns
