Hi,
I have a crosstab with 2 different dimensions in the rows and another dimension in the coloms.
As measures I have absolute numbers and a percentage based on the total of top level of the dimensions in the rows.
I want an extra percentage which is based on the total of the second level after the 1st drill down on a dimension in the rows. And changes again when another drill down is performed in which case the percentage is calculated on the total of the third level.
Can someone help me with this? Thanks
Tibo