1 Reply Latest reply on May 17, 2017 10:46 AM by Johan De Groot

    table calculations with hierarchy

    Tableaunew learning

      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@@