Hope you can help me in this
I have a dataset with 2016- 2018 sales data. Somehow i want to select single value year or month and the table in the middle calculate the prior year ( same month last year) value.
but no luck i can only get 0
also there is some restriction where
1. No time (Year / Month ) in upper Row
2. The grand total option ( Total Option sum) has to be selected later on
Hope you can help. Thx
Retrieving data ...