Filer within Pivot Table
 

Hi,

Using Windows 2000 and Excel 2000

I have created a pivot table which correctly shows the data returned,
however, I don't want to show entries where the total (sum of data) is equal
to 0 (a zero). I've tried to turn on Filter but this option isn't
available.

Any pointers most welcome.

Rob

Debra Dalgleish has written code for this

http://groups.google.es/advanced_gro...=lang_en&hl=en

search for hide zero value pivot table and in author put Debra Dalgleish

--
Regards,

Peo Sjoblom

(No private emails please)


"Rob" wrote in message
...
Hi,

Using Windows 2000 and Excel 2000

I have created a pivot table which correctly shows the data returned,
however, I don't want to show entries where the total (sum of data) is
equal to 0 (a zero). I've tried to turn on Filter but this option isn't
available.

Any pointers most welcome.

Rob

Thanks Peo, I'll try this in the morning.

Rob
"Peo Sjoblom" wrote in message
...
Debra Dalgleish has written code for this

http://groups.google.es/advanced_gro...=lang_en&hl=en

search for hide zero value pivot table and in author put Debra Dalgleish

--
Regards,

Peo Sjoblom

(No private emails please)


"Rob" wrote in message
...
Hi,

Using Windows 2000 and Excel 2000

I have created a pivot table which correctly shows the data returned,
however, I don't want to show entries where the total (sum of data) is
equal to 0 (a zero). I've tried to turn on Filter but this option isn't
available.

Any pointers most welcome.

Rob