Hello All,
I have a requirement where I bring in person details as rows and year (level-1)& month(level-2) as the columns and amount spent as the measure in the crosstab. My requirement is to show the year and months in the descending order meaning from latest data to oldest... 2007-dec to 2007-nov...2006-dec.
The hard part is to sort the measure in desc order for the latest year and month. i.e., for only 2007-dec I need to sort the measure value in desc order. How do I sort on this particular dynamic value in column?
Regards,
S