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

    Issue with calculated dimension in pivot table

    Ferha Jafri

      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