| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Not including blank fields in pivot tables
Hi all,
A quick question... I want to create a pivot table that provides sum of fields, but the column that I'm using contains blank fields, and the the pivot table displays these as blank, but still takes the sum of these fields and adds them to the overall total. How can i tell the pivot table to ignore blank fields? Thanks in advance. Pinda / |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pivot tables reports - altering display of (blank) cells | Excel Worksheet Functions | |||
| Pivot Tables & not printing blank rows (revisited) | Excel Discussion (Misc queries) | |||
| Pivot Tables & not printing blank rows (revisited) | Excel Worksheet Functions | |||
| Blank Cells in Pivot Tables | Excel Discussion (Misc queries) | |||
| Pivot Tables - Variance and % Variance fields | Excel Discussion (Misc queries) | |||
Threaded Mode
