3 Replies Latest reply: Jan 19, 2016 4:54 AM by Ridhaa Hendricks RSS

    Pivot table limiting column expression

    Ridhaa Hendricks

      Hi There

       

      I have a pivot table

       

      in my Pivot table I have two expressions

       

      Sum(Actuals)- I would like to see this by month

      Sum(KPI) -I only want to see this column once, as this is the KPi for the Year.(This is a very complex expression and I cannot use it as a dimension)

       

      JanFebMarKPI Target
      Brand1000120011001500

       

      any Idea how I can achive this.

      This is what I am currently getting:

       

      JanKPI TargetFebKPI TargetMarKPI Target
      Brand100015001200150011001500

       

      Your assistance is appreciated.

      Thanks