|Dynamic Sorting on Derived Columns of Crosstabs [message #693483]
||Wed, 06 July 2011 14:48
Registered: June 2011
I'm trying to do dynamic sorting on crosstabs, where the users can specify which column they would like to order the rows based on .
With the help of the above links, I can do dynamic sorting on aggregation columns with API. But for the Derived Columns , it seems does not work.
For example, amount of sales, amount of rent, and amount of tax are 3 aggregation columns of the crosstab, I can do sorting on any of them using API.
But now I have a derived column [amount of mystery income], whose expression is total([amount of sales]* [amount of rent] *[amount of tax]) / total([amount of rent]*[amount of tax]), is there someway to do dynamic sorting on this derived column please?
Thanks in advance.
[Updated on: Thu, 07 July 2011 14:46]
Report message to a moderator
Powered by FUDForum
. Page generated in 0.04538 seconds