Hi
I need to sort a pivot table on the "Grand total" column. I have tried using the recorder, but i can't get it to work.
The code I have is below, would anyone know how to finish it off please?
Dim sht As Worksheet
Dim pvtCache As PivotCache
Dim pvt As PivotTable
Dim rgPivot As Range
Dim...