Iain Munro
New Member
- Joined
- Aug 29, 2020
- Messages
- 9
- Office Version
- 365
- Platform
- MacOS
Morning
I have a Pivot Table that has 77 rows of clients - after about row 29, the quantity column goes to 1 for the remaining items.
When I created a Pivot Slicer, it would be nice to just to be able to select from say the top 10 clients rather than a slicer that has 77 values to chose feom.
Is there a way to do this ?
Iain
I have a Pivot Table that has 77 rows of clients - after about row 29, the quantity column goes to 1 for the remaining items.
When I created a Pivot Slicer, it would be nice to just to be able to select from say the top 10 clients rather than a slicer that has 77 values to chose feom.
Is there a way to do this ?
Iain