15 Replies Latest reply: Aug 22, 2017 1:36 AM by Hemeswara Reddy RSS

    Compare an amount for different years

    Florian Lemarquand

      Hello everyone,

       

      I would like to compare the sales amount for each of my customer for different years and be able to know if the sales amount for a customer in 2017 is upper or lower than in 2016.

       

      For example, if one of my customer in 2016 had a sales amount of 1M€ and 950k€ in 2017 i would like to display the 2017 amount in red.

       

      This should be done in a pivot table with my "Customers" and the "Years" as dimension and my "Sales Amount" as a measure

       

      Don't hesitate to ask me further details if my explanation aren't enough clear.

       

      Thanks in advance,

      Florian