Pivot table and Calculated item field
Posted by Jon H on January 15, 2002 8:02 AM
I have a large pivot table that has a calculated item field (in my case, the calc item is col.1-col.2).
When I use the calculated item field, it lists every calculated item, regardless of whether there is actually data in the row it is calucalting. So I end up with the pivot table listing a lot of zero info, and it makes for a table a lot longer than it needs to be.
Is there a way the extra lines with zero in the calc item field ca be made to be hidden?