Hi,
I have a pivot table that i have manually sorted(dragged and dropped rows) to put the data in the right order, however whenever i select and unselect a filter from a connected slicer the order goes back to what Excel thinks it should be.
an example of the data i sorted would be:
1
2
3
4
5
51-60
101-200
When i use the slicer it sorts it this way:
1
101-200
2
3
4
5
51-60.
Is there any way of stopping this happening?
I have a pivot table that i have manually sorted(dragged and dropped rows) to put the data in the right order, however whenever i select and unselect a filter from a connected slicer the order goes back to what Excel thinks it should be.
an example of the data i sorted would be:
1
2
3
4
5
51-60
101-200
When i use the slicer it sorts it this way:
1
101-200
2
3
4
5
51-60.
Is there any way of stopping this happening?