I trying to sort my Pivot table using Expression option from sort properties but I am not able to achieve what i am looking for.
I have two fields BPclass code and Unit type, from these I am using only Unit type as a dimension in the table and in pivot table this unit type should be sorted out by using above two fields (not Ascending or Descending order) I am looking for custom sorting like rounded in yellow circle in attached screen (Right side of the screen shot)
Here I can not use match or if statements because i have 25 to 30 unit types and codes so i think its difficult. Few more may get add in future.
I don't want create new concatenated field in the data model because data model is freeze and user's do not want to see the codes in the table.
So do we have any other work around for this.