Dynamically sorting on coulmn heading in crosstab report

[carvy_49]

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

[GBIS10]

Have you discovered the solution to this question? I would be very interested in the explanation.

[bonniehsueh]

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