| 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 |
| 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) | |||
Threaded Mode
