Pivot Calculated Fields
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 |
All times are GMT +1. The time now is 03:38 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com