Default sort order in pivot

[Kaspars]

Hi there,

Could someone help me with this - is there a possibility to define a default sorting order for a field in pivot table? When I'm creating a pivot it makes alphabetical sorting order but I need one strict order and therefor I need to drag and drop every time. As I have many files with same structure of data I would like to make a default sorting order that is based on a values list and I would be able to use it in any file with same data structure, field names and even value names.

Thanks in advance,

Kaspars

 

[Chihiro]

You can use Custom Sort List.

See following:
https://support.office.com/en-us/ar...tom-list-def8ff2b-681a-4fc3-9bd2-a06455c379e1
https://support.office.com/en-IN/Ar...24430830450a?ui=en-US&rs=en-IN&ad=IN&fromAR=1

 

[Kaspars]

Wow, nice!!!

Many thanks!