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


      any Idea how I can achive this.

      This is what I am currently getting:


      JanKPI TargetFebKPI TargetMarKPI Target


      Your assistance is appreciated.