Hi Mynda,
I have sorted the attached pivot by the last column in descending order. I intend to use this for my dashboard where when I click on a brand, a secondary pivot will show a drilldown of the products under that brand.
Is it possible to sort the Brand slicer in the same order as the main table so that I can reduce the slicer to just a button(as shown) to correspond to each Brand?
Thanks,
Moavu
Hi Moavu,
Slicers sort in alphabetical order. If you want to override that you can use a custom list to enforce your own sort order. I explain how in this post:
https://www.myonlinetraininghub.com/sorting-excel-date-slicers
The limitation is that you have to manually maintain the custom list, it won't update based on changes in your PivotTable sort order.
Mynda
