i have created a hierarchy in my dataset and tried to make a table calculations to work on each level to calculate % of total.. but it's not working... if i calculate for the depest level then on collapsing hierarchy, it doesn't show right data, if i calculate on higher level then on expanding the hierarchy it doesn't show right calculations. i have replicate results on super store data in attached one..
how can i make my calcuation work on each level.
Thanks You@@
Hi,
If you compute the calculation on 'Pane Down' - isn't that the way you want to calculate the percent of total?
Kind regards,
Johan de Groot