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:

      example.PNG

       

      I tried this formula:

       

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

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

       

      This is what I get:

      example2.PNG

      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!