Sort on Excel Pivot table data field

[alison233]

I know how to sort Excel Pivot table row and column fields, but I wonder - does anyone know if it is possible to sort on a data fiekl, without copying the pivot table and pasting special values elsewhere?

I suspect isn't possible - but just in case . . .

Best wishes

Alison