Hi All,

I am extracting data from an Access Sheet into Excel and forming a pivot.
I have created a calculated field in the pivot.
I want to sort the pivot to exclude all rows where the calculated field is equal to 0.
However I am unable to exclude these.

Does anyone know how to do this without creating a new pivot or amending the core data in Access?

Any help would be great.

Thanks
GarToms