sorting the dimension in pivot table

[#1]

Take a look at my pivot table below (example only).

Job is one of my dimensions and it diplays its contents as indicated below (Type3, Type 2 etc.).  How can make Type3, Type2 display in ascending order. Example: Type1, Type2, Type3, Type4

    Testname              Job      Type3          Type2          Type4          Type1

               AN                                    9               9                    9               9

               BN                                    7               7                    7               7

               CN                                    6               6                    6               6

[Nicole-Smith]

On Sort tab, you should be able to choose the dimension and do a sort by text.

[Gysbert_Wassenaar · Accepted solution]

Set the sort order of the Job dimension to Text A->Z on the Sort tab of the properties window.

[#4]

So Job is not one of the options that is displayed within sort, so this is what I did, within sort, select any one of the dimensions, in my example above I would select Testname and add expression =job then select ascending order and text (A-Z).

[#5]

Thank you for response

[#6]

Thank you for your response