0 Replies Latest reply: May 22, 2018 7:02 AM by Hoang Tu Nguyen RSS

    YoY Difference and Growth

    Hoang Tu Nguyen

      Hello everyone,


      I'm looking for a method to visualize the difference between two years in a pivot table.


      This is what I would like to get:



      I tried this formula:


      Sum( { $<[DocumentYear]={$(=max(DocumentYear))}>}  Revenue)

      - Sum( { $<[DocumentYear]={$(=max(DocumentYear)-1)}>}  Revenue)


      This is what I get:


      I guess each column filters the data for the choosen year and it is not possible to use the formula for my case.


      Do you know a method for my case?


      Thank you in advance!