Sorting monthly crosstab(multi column) by the total

[praveen224]

All,

I have a crosstab report that looks like this:

Jan Feb ...... Total
Rev Budget %var Rev Budget %var Rev Budget %var
Name1 $100 $200 50 $50 $200 25 $500 $2000 25
Name2 $150 $500 60 $20 $200 10 $300 $1000 33


I used a method that lbass provided to come up with %var - using display string.
Question I have is - can I sort this report by the Total %var in descending order - Total %var also uses Display string.

Thanks for your help.
Praveen

 

[lbass]

Sorry, no, you can't sort by that. If this is critical, you should instead create a manual crosstab--and even then you might have to create the summaries with SQL expressions in order to use group sort on the calculated percentage field.

-LB

 

[praveen224]

Thanks - I might have to go the SQL route....