Excluding a value from Pivot Table Count

[lpw0806]

Hi -

I have a pivot table where columns are counting values from the raw data. However, one of the values that is being counted is "" (aka just a blank / empty cell that is a result of a long IF statement). Is there a way to exclude this value from the count? I tried changing the formula in the raw data so instead of "", the value was "N/A" - but I am still having the same problem.

I've done a lot of googling and it seems like I could do something like create a calculated field - but I am having trouble figuring that out as well. I'd like to avoid adding more columns (ex - IsBlank?) to the raw data since it is large to begin with.

Any advice / help would be so appreciated!

THANK YOU!

 

[Misca]

A Quick & Dirty solution: Try adding a helper column to your data where the value is 1 for every row where there's a value and 0 for empty rows. This way you could use SUM instead of count.

Also, if your other values are numbers already there's the "Count Numbers" option under the "Summarize Values By" / "More Options".