Hi
I have a sample dataset like this:
| Date | Region | Product | Sales |
| 1/01/2014 | Region A | Product A | 100 |
| 20/02/2014 | Region A | Product B | 150 |
| 11/04/2014 | Region A | Product A | 102 |
| 31/05/2014 | Region A | Product B | 153 |
| 20/07/2014 | Region B | Product A | 105 |
| 8/09/2014 | Region B | Product B | 150 |
| 28/10/2014 | Region B | Product A | 115 |
| 17/12/2014 | Region B | Product B | 173 |
| 5/02/2015 | Region A | Product A | 117 |
| 27/03/2015 | Region A | Product B | 176 |
| 16/05/2015 | Region A | Product A | 121 |
| 5/07/2015 | Region B | Product B | 173 |
| 24/08/2015 | Region B | Product A | 132 |
| 13/10/2015 | Region A | Product B | 199 |
| 2/12/2015 | Region A | Product A | 135 |
| 21/01/2016 | Region A | Product B | 202 |
| 11/03/2016 | Region B | Product A | 139 |
| 30/04/2016 | Region B | Product B | 199 |
| 19/06/2016 | Region A | Product A | 152 |
In a table or graph, I like to calculate Year-on-Year growth like this:
| Month | Region | Product | This year Sales | Last year Sales | Growth |
Is there a way to calculate 'Last year Sales' from the dataset, e.g. using set analysis?
I googled a lot but could not find an answer. If anyone can help me, it would be much appreciated.
Kind regards
Thomas
