5 Replies Latest reply: Oct 1, 2013 8:12 AM by Ferha Sharma RSS

    Issue with calculated dimension in pivot table

    Ferha Sharma

      Hello Everyone,

       

      I need help i have to create a pivot table in whicth the hierarchy is as product name,product grouping,sbu,subdivision,div,zone in this i have to push the zone upwards and have to create 4 expression for current and previous MTD and current and previou YTD my issue is i have to reduce the data fileds in zone dimension as i have 10 zones in total and i want to show 3 zones in the upward direction,please help it is urgent.

       

      Thanks in advance

      Ferha Jafri