1 Reply Latest reply: May 2, 2018 4:12 AM by Tauceef Sheikh RSS

    how to add a manual column in pivot table

    Tauceef Sheikh

      Hello Friends,

       

      I am creating a pivot table where I have one column "SLA Description" in Rows section with below code:

      =ValueList('Demand ASA','First Tier Resolution','Incident P1 Response Critical')

       

      with that a month column and a measure using pick(match()) function.

       

      I want to add one more column under Rows "SLA Threshold" using below code:

      =Pick(Match(ValueList('Demand ASA','First Tier Resolution','Incident P1 Response Critical')

      ,'Demand ASA','First Tier Resolution','Incident P1 Response Critical'),

      Col1,Col2,Col3)

      but it is not displaying anything. Col1,2,3 values are coming directly from a excel file.

       

      My ultimate aim is below table:

      pivotissue.png

      Any help would be great.

       

      Regards,

      Tauceef