2 Replies Latest reply: May 23, 2018 4:35 AM by Hoang Tu Nguyen RSS

    YoY Difference and Growth

    Hoang Tu Nguyen

      Hello everyone,


      I'm looking for a method to visualize the YoY difference and growth in a pivot table.


      For example:




      I tried this formula:


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

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

      But I don't get what I want:



      I think the problem is, that the pivot table filters the data for the years.

      Do you know a method for this problem?


      Thank you in advance!