Not including blank fields in pivot tables

B

Bhupinder Rayat

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 /
 
J

John Michl

There should be a drop down list at the top of the column (typically
the left most column). Click on the drop down and you'll see all of
the field values. Uncheck "(blank)" and that should do the trick.

- John
 
Top