Pivot Table - data is including blank cells

[chrono2483]

Hello,

I have a pivot table. When using the 'Count' values field setting, my table is picking up blank cells as well from the original column. The formula is that if the data is 0 or error, to return " ", and if the returned value is < or > X, to return 1 or 0. I want the pivot table to only count those cells in the column with actual values (1/0) and ignore the blank ones.

Am I doing something wrong?

 

[qwerty1234]

You can filter out the blank cells. If you look at the Field List (Click somewhere in the pivot table and then the tab at the top "Pivot Table Tools" --> "Options" tab, far right to view it if you don't already), you can put the field with the blank cells in the "Report filter" box. Then you can check the box "select multiple items" and uncheck the blanks. Or you could do this right from one of the fields you have on the pivot table. Hope that helps