1 Reply Latest reply: May 3, 2017 5:16 AM by Anil Babu Samineni RSS

    Pivot Table Condition

    Ahmad Kastero

      Dears,

       

      I'm trying to build a report in a pivot table with a condition in the expression based on the dimension column . and this is the details:

       

      as you see the below table I have the type and A, B and this is the scenario; if the Type is Meat add 100 and if the Type is Veg add 50.

      Type is Dim Column.

      A is the, for example, the sales.(1st expression)

      B is the result. (2nd expression).

       

      it possible to but a condition in the expression based on the Dim in the same pivot table.

       

         

      Type AB
      Meat200
      Veg321
      Meat343
      Meat765
      Veg234