Hi,
Please see the attached doc.
I have a situation where I have to do a sorting only on current month (September-marked in red)column in a crosstab. My sorting sequence from top to bottom are: Postive %, Negative %, and Empty cells. If we can get rid of the Empty cells that would be really great.
So I am expecting to see sequence like this (from top to bottom):
2630%, 49%, 34%, -15%, -28%,… So the corresponding row dimension will also move accordingly.
How can I achieve this? I have spent almost 3-4 days for this issue but no success…
Thanks in advance!
Sameer
Issue.doc (50.0 KB)
sam_dabs (BOB member since 2008-09-25)