NickOnTheNet
New member
- Joined
- Feb 3, 2018
- Messages
- 1
- Reaction score
- 0
- Points
- 0
Hi all!
I am just looking for a pointer to a suitable youtube video or resource to help with the task in hand.
(I am certain I have seen something covering this in the past but there is just so much out there!)
I want to compare two years revenues by customer and product in one pivot chart, but I also want to control which years are displayed by using two separate slicers. That way I can compare say 2010 with 2014.
The icing on the cake would be to have the corresponding year in one slicer disapearing when selected in the other! (But hey, no icing is good too!) :smile:
My data is already in the Data Model with sale date, product, customer and revenue in the cols.
Thanks for your time guys!
I am just looking for a pointer to a suitable youtube video or resource to help with the task in hand.
(I am certain I have seen something covering this in the past but there is just so much out there!)
I want to compare two years revenues by customer and product in one pivot chart, but I also want to control which years are displayed by using two separate slicers. That way I can compare say 2010 with 2014.
The icing on the cake would be to have the corresponding year in one slicer disapearing when selected in the other! (But hey, no icing is good too!) :smile:
My data is already in the Data Model with sale date, product, customer and revenue in the cols.
Thanks for your time guys!