9 Replies Latest reply: Feb 2, 2015 8:15 AM by Volha Burak RSS

    Expression Pivot table

    Volha Burak

      Hi,

      I have data schema:

      I want to do this pivot table:

      But I can't implement formula:

      AVG(

      for each Product

      if(Revers = 1)

      {

        ((Last Price in Data range (Year, quarter, month) + Sum Premium in Data range)/(First Price in Data range + Sum Premium Prior Data range)) - 1

      }

      else

      {

        1-((Last Price in Data range (Year, quarter, month) + Sum Premium in Data range)/(First Price in Data range))

      }

       

      Unfortunately I can not understand how to group the data in Expression and how to work with the pivot table dimensions.

       

      Thanks so much