Excel 2002 -> Problem with calculated fields in Pivottable
Hi,
I have created a Pivot table and use a calculated field. Now I want to eleminate the "0" of this calculated field. Normally I would drag the field into the page area. But this does not work the normal way. I don't want to change the original database. Does anyone know the possibilty of using a calculated field in the page area of a pivot table? Or another way to avoid the zeros ? Thanks foru your help |
All times are GMT +1. The time now is 10:19 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com