13 Replies Latest reply: Jan 6, 2016 9:58 AM by Jim Chan RSS

    Pivot Table, how to add expression

    Jim Chan

      Hi guys,

       

      tricky situation!! help!!

       

      ok, I have a client , need to create a Pivot table with expression on the left( Receieved(Cases), Investigated(Case), Confirmed Fraud Cases)) - All these are expression.

       

      Then, my client want to see the value in Current Month & forecast month as well. It looks like both of these should in expression as well.

       

      So, how can i the Current Month and Forecast month expression as the dimension?

      error.png

       

      Rgds,

       

      Jim Chan