Hi:
Ive attached a file . . .
i'm trying to add calculated fields that show 2019 vs. 2018, 2020 vs 2019, and 2020 vs 2019.
Would appreciate any guidance
Thanks / Steve
Hi:
Ive attached a file . . .
i'm trying to add calculated fields that show 2019 vs. 2018, 2020 vs 2019, and 2020 vs 2019.
Would appreciate any guidance
Thanks / Steve
Steve
Thanks for adding the file (nearly always helpful).
In the attached version of your file, I've created a pivot table from your data with Part_No for rows and Ship_Date for columns (automaticaaly grouped by Year) and used the Value field in the table values (summed by default).
Then I've added Value again but renamed it from "Sum Of Value2" to "Change from last year" and in the field settings left it to Summarise by Sum but clicked the Show Values As tab and set it to Show values (dropdown)= "%Difference from", Base Value="Years" and Base item= "previous" so the feild return the % increase or decrease from what was sold in the previous year.
Is that what you were hoping to show?