Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
updating pivot table to include additional rows | Excel Discussion (Misc queries) | |||
Change Data In Pivot Table | New Users to Excel | |||
Pivot Table - Multiple consolidation Range | Excel Worksheet Functions | |||
Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
Pivot Table Problems | Excel Discussion (Misc queries) |