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?