How to sort by Total in Pivot

[#1]

How can I sort the data in a Pivot table by the "total Omzet" column in the pivot below ?

Thanx in advance

Holke

[Anonymous]

Hi Holke,

When you select the sort value in the properties of the chart, you will need to use the expression option. Try using the TOTAL qualifier in the expression sort....

=Sum(Total Omzet)

Cheers.

Ad.

[#3 · Accepted solution]

If you set the sort on the field labeled "K" with the expression Sum(Omzet) before any of the sorting for the field labeled "B", it should sort by total.