1
I would like to know if there is a way of preserving the order within a pivot table after using a filer/slicer.
More specifically, I have created a pivot that shows data being filtered by category slicer, and I rearranged the data in a certain way. Now, if I use the slicer to see a certain category, and later on I remove the filters, it changes the order of what I rearranged.
How can I do this while preserving the original order?
user564582
Posted 2016-02-28T08:55:02.123
Reputation: 11