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:

       

      example.PNG

       

      I tried this formula:

       

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

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


      But I don't get what I want:

       

      example2.PNG

      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!