Does anyone have any suggestions on how I can order a matrix table based on
the last month column of multiple months? As an example, my MDX query would
return:
Product A - 2004 - January - 20
Product A - 2004 - February - 5
Product B - 2004 - January - 10
Product B - 2004 - February - 15
Which I would like to output as (descending order on last month, i.e.
February):
2004
January February
Product B 10 15
Product A 20 5
Sorting by the measure will order them by the first column (i.e. January),
and none of my attempts to order the data in MDX returns the order I would
like.
Any help would be appreciated.
Thanks.