I want to ask, if it is possible to sort the crosstab rows based on the row totals with some advanced expressions?
I have a crosstab which would have always only 2 “columns”, showing profit. First is showing data from previous year, the other from the current year. On the row total I’m showing difference between the years (along with percentage) using GetVar()/SetVar() machinery. Now, I would like to sort data by this total column. But I’m unable to do it and I think it isn’t possible to sort on column, which is using GetVar() et.al…
Am I right? Could this behavior be achivied by some other means?