Will i be able to order/sort crosstab data as mentioned below .
I have NAMEas row group and STATUS as column group.
Again Vol and Sum are static texts added.
Value of Vol and Sum corresponds to 2 measures defined.
------------------------------------|
STATUS--------------->| status1 |
NAME-------------------|Vol|Sum|
A................................2...100
B................................1....50
C................................4....34
I can sort on NAME and STATUS
What is required is ---I want to sort on Vol and/or Sum.
See the required result below.
------------------------------------|
STATUS--------------->| status1 |
NAME--------------------|Vol|Sum|
B.................................1....50
A.................................2...100
C.................................4....34
Recommended Comments