how to keep data always in ascending order (pivot table/chart used)

Is there a way to keep the data sorted (ascending order) each time, no matter what code I pick?

For example, my first screen shot below, I have selected in my slicer "px code" 99291. Afterwards I manually sorted the data (via pivot table) to be ascending order.

Capture.PNG


My second screen shot below, I went to my slicer and selected "px code" 99239. However, my data is no longer in ascending order and I have to manually sort it again.

1.PNG


Is there a way to keep my data automatically in ascending order regardless of which code I pick? I want to be able to click on any code and always have the data in ascending order.

Hi,
I think it's better to share your workbook.
But you can try by putting the field Px Code in the row section in second position, sort the data without filter Px Code, then try to filter by slicers.
Inform us if this method work ... and add a reputation

sheet attached.

sheet 3 is pivot table, sheet 4 is where I placed my charts/slicers.


I tried but failed, not sure what I am doing wrong. Please take a look.


If you can help make my data always in ascending order (regardless of which code I pick or person, that would be soooo helpful!

Thank you


*ignore my ugly charts , I was starting to format them. (not done)

Hi,
you can put the Px Code field as first row in the pivot table, sort the values without filtering then each time you filter, the values will stay in the sorting order.
try with this worksheet and tell us if it worked.
charge names eeps24.xlsx

thank you guys I am all set... as a thank you, take off November 24th...WITH pay!

You're welcome