Pivot Calculated Fields

G

GarToms

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
 
Top