Can anyone help me with creating a calculated field for calculating sales this year and Sales last year by month and allow the user to select the year for this year and the year for last year?
Data is by day
What I want the output to look like is:
I tried various ways and can't get it to work by month, any help is appreciated!
3 answers
please check the attached workbook. it uses the sample data as you presented.
hope this helps! (modified to add method 2 sheet for the filter)
