5 Replies Latest reply on Sep 21, 2017 3:02 PM by Hari Ankem

    Identify products with largest year over year change

    Andy Dalugoda

      I would like to create a dashboard that shows year over year change by product category and sort them largest to smallest

       

      I have sales data from April of 2016 to August of 2017. latest data i have available is for August of 2017, i would like to compare the running total from April 2016 to August 2017 and compare the change to the same time period last year (April of 2016 to August of 2016)

      fiscal year: April to March

       

      I would also like to make data dynamic in a way when i add September data then it would calculate the running total for April to September 2017 and calculate the difference from same time last year.

       

      hope all that makes sense and thanks so much in advance for your help