boxsterman
Active Member
- Joined
- Apr 16, 2002
- Messages
- 285
Hi folks,
the data is set up so that the actual data with figures runs in several columns across.
The pivot sums up each column when pulled in, the problem is that there are several rows with zeros in the pivot table.
Is it possible to have the zero's removed? I tried to incorporate them into the page field as well, and hide zeros, but then none of the data remains.
Make sense?
J
the data is set up so that the actual data with figures runs in several columns across.
The pivot sums up each column when pulled in, the problem is that there are several rows with zeros in the pivot table.
Is it possible to have the zero's removed? I tried to incorporate them into the page field as well, and hide zeros, but then none of the data remains.
Make sense?
J