Is it possible to sort a pivot table in a particular order?

[anthony_kinsell]

Is it possible to sort a pivot table in a particular order ignoring values?

EG:

Wages & Salaries

General & Admin

Rent, rates & service chg

Professional Non-Exec Directors

Professional consultancy

IT

Finance

Legal

Insurance

[tresesco · Accepted solution]

In the sort tab, try by expression:

Match(YourField, 'Wages & Salaries', 'General & Admin' , ....)

[SreeniJD]

Hi

By default QV will not recognize which order you would like to sort it out... if you have any custom order in your mind, tell to QV that you are going to sort out with your custom order and provide ranks to the values and then go for ascending or descending..

HTH

Sreeni

[anthony_kinsell]

Cheers