in a crosstab report,
i have last 3 months (example: March, April, May) data in the column side.
row side some product line. and in the cell measure.
if suppose i click on March Month the data will display Ascending order based on March month
if suppose i click on April month the data will display Ascending order based on April month
if suppose i click on May month the data will display Ascending order based on May month.
please help
Have you discovered the solution to this question? I would be very interested in the explanation.
This is a common request. Search on cognoise and you'll find many posts. There are several ways you can do this.
Javascript is one way, but I recommend against using JS as it doesn't upgrade well.
Haven't tried this technique yet, but it looks promising: http://it.toolbox.com/wiki/index.php/Dynamically_sort_columns%2C_no_code_required%2C_c8