Sort order of dimensions in tabular data model
I was just wondering if there is a way to sort dimensions when you view the PivotTable Fields in Excel? The default is alphabetical, but I would like to have my own custom order. I suppose I could prefix the dimensions with 01, 02, etc., but
I would rather custom sort them, if possible.
September 1st, 2015 9:35am
No, Excel always sorts dimensions alphabetically unfortunately there is no way to change this.
Free Windows Admin Tool Kit Click here and download it now
September 1st, 2015 4:47pm