Hi All,
I have a problem that I dont quite understand how to solve. I have researched quite a bit and have only gotten more confused.
What i am looking for is to have a graphic that based on a year filter selected, shows the current years volume per month and in the tooltip, shows the change in volume from the corresponding month last year.
Unfortunately, when I use the Table calculation to calculate the difference from, it is always taking the previous month, rather than the previous years month. See below for a screenshot.
I am unsure of how to resolve this issue. Any help would be greatly appreciated.
I have also attached a workbook for reference.
Kind regards,
Anthony
6 answers
