Forum Discussion
year over year variable
Trying to create an easy year over year growth chart but not finding any really simply charts Would love to show it on a water fall chart Also not easy to find calculation for year over year ...
Thank you for your help on this, I am almost there I think
Here is my formula
PrioryearSales = CALCULATE(SUM('Sales Data Structure'[AMOUNT]),ALL('Sales Data Structure'[AMOUNT]),PREVIOUSYEAR('Sales Data Structure'[Shipping Date]))
The table looks like this, it is a list of individual invoices that I am summing up using the Amount column
| DOCUMENT NO. | Z-NUMBER | SHIPPING DATE | AMOUNT | SHIP TO STATE | Rep |
| 6618 | 296 | 10/8/2013 | $ - | OK | RL |
| 16458-1 | 410 | 10/8/2013 | $ 35,464.00 | WI | |
| 16529-2 | 410 | 10/8/2013 | $ 30,628.00 | WI | |
| 16626 | 210 | 10/9/2013 | $ 1,980.00 | FL | RL |
| 16607 | 220 | 10/9/2013 | $ 2,240.00 | WI | JTS |
| 16547 | 220 | 10/9/2013 | $ 160.00 | WI | JTS |
| 16596 | 220 | 10/9/2013 | $ 101.00 | WI | JTS |
| 16558 | 229 | 10/9/2013 | $ 810.00 | IN | |
| 16610 | 231 | 10/9/2013 | $ 3,570.00 | WI | JTS |
| 16609 | 231 | 10/9/2013 | $ 2,460.00 | WI | JTS |
In your provided information, your formula should work.