Hi,
I am trying to show two figures at the same time and feel like I've tried everything and researched everything but cannot find an answer (so don't know if this is possible or not).
I want to use my slicer to pick a date range to give me total sales for that period, but then I also want another pivot to show total sales for the same period last year.
So on the attached example, it is showing Total Revenue of 2326 for 28th Feb 2019, but how can I also show that total sales for the equivalent day last year (1st march 2018) was 6011, all by using just the one slider?
Is it even possible?
Any help much appreciated.
Thanks
Chris
I am trying to show two figures at the same time and feel like I've tried everything and researched everything but cannot find an answer (so don't know if this is possible or not).
I want to use my slicer to pick a date range to give me total sales for that period, but then I also want another pivot to show total sales for the same period last year.
So on the attached example, it is showing Total Revenue of 2326 for 28th Feb 2019, but how can I also show that total sales for the equivalent day last year (1st march 2018) was 6011, all by using just the one slider?
Is it even possible?
Any help much appreciated.
Thanks
Chris