0 Replies Latest reply: Nov 27, 2017 12:10 PM by Rohit Kumar RSS

    Parent Column Name in Pivot table

    Rohit Kumar

      Hi Techies,

       

      I have a pivot table which has one dimension and 5 calculated measure which has label with variables. The pivot look like:

       

                         Measures

      Brand  Cal1,Cal2 Cal3 Cal4 Cal5

      A

      B
      C

      D

       

      My requirement is :

       

                         Measures

                     MTD               YTD

                 Cal1,Cal2 Cal3 Cal4 Cal5

      Brand 

      A

      B
      C

      D

       

      I want to put MTD for Cal1 and Cal2 then YTD for Cal3, Cal4, Cal5.

       

      Please guide me how to do it, Do i need to add one more dimension with MTD and YTD values or something else ?

       

      Best

      Rohit