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

# Identify products with largest year over year change

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

• ###### 1. Re: Identify products with largest year over year change

I created 4 calculated fields as shown below.

And here is the output:

The sorting has been specified by the following:

The workbook is attached. Hope this helps.

• ###### 2. Re: Identify products with largest year over year change

Thank you for the quick response but unfortunately i'm having little trouble

Example:

Product Rapid Revolver: FY April 2017 to FY August 2017 running total is 262 (20+29+86+24+103)

Same product for FY 2018 is 129 (20+25+46+15+23)

the difference i was looking for is 129-262 = (133)

hope that makes sense and sorry if i wasn't clear enough in my original post

• ###### 3. Re: Identify products with largest year over year change

Yes, the confusion is because of the below statement in the description. Anyway, will correct and update shortly.

• ###### 4. Re: Identify products with largest year over year change

so sorry about that, really appreciate the help

• ###### 5. Re: Identify products with largest year over year change

Here you go:

I created 4 more calculated fields, Fiscal Year, Fiscal Month, Latest Reporting Fiscal Year and Latest Reporting Fiscal Month. It can probably be simplified but this will help in debugging easily. Also modified are the formulas for the Cumulative CY and Cumulative PY. You can refer them in the attached workbook.