Dynamic Sorting on Derived Columns of Crosstabs [message #693483] |
Wed, 06 July 2011 14:48 |
Scroon Messages: 28 Registered: June 2011 |
Junior Member |
|
|
Hi,
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 .
I've read
http://birtworld.blo...-scripting.html
and
http://www.birt-exch...pt/#description
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.03790 seconds