Hi, I have a selection of basic pivot tables measuring volume of diff prod categ sales.
However, I would like for it to have greater context rather than changing month slicers.
Ideally:
1. Week to date (mon to fri). Variance compared to last week (wk to date)
2. Month to date. Variance compared to last month (month to date). *Also maybe the same month figure but for previous year. Eg jan 2022 mtd
3. YTD Variance compared to last year (ytd)
Is there a method to achieve this in excel please? Any general pointers or literature to help me?
Im guessing there may be in Power Bi however such software is beyond me at this point.
Many Thanks
Gareth
However, I would like for it to have greater context rather than changing month slicers.
Ideally:
1. Week to date (mon to fri). Variance compared to last week (wk to date)
2. Month to date. Variance compared to last month (month to date). *Also maybe the same month figure but for previous year. Eg jan 2022 mtd
3. YTD Variance compared to last year (ytd)
Is there a method to achieve this in excel please? Any general pointers or literature to help me?
Im guessing there may be in Power Bi however such software is beyond me at this point.
Many Thanks
Gareth
