Pivot Table/Calculated Field Question

**friedman_art** · 02-23-2009, 12:42 AM

I have attached a simple test file. The data tab has two columns in the pivot range. The third column is _not_ in the pivot range, but is there to show the result I'm trying to get with the pivot.

The idea is to count the number of people whose entry dates are greater than 2/1/2009. My third data column gives a correct result, but a similar formula in the calculated field of the pivot table gives a completely wrong result (a date), where my goal is to generate a zero, a one, or a sum of zeros and ones.

It could be a formatting issue, but that would not explain why all the pivot results have the _same_ wrong answer.

I'm new to PTs and calculated fields, and expect I've made a naive mistake that an expert could easily spot.

Any help would be appreciated.

Thanks,
Art

**Paul** · 02-23-2009, 12:51 AM

Hi Art,

I think you're getting incorrect results because your Pivot Table's calculated field ("Adds") is set to check if 'EntryDate' is greater than "DATE(2008,2,1)" instead of "DATE(2009,2,1)". Change that and your pivot data should be correct.

**friedman_art** · 02-23-2009, 02:08 AM

Paul, thanks for catching my incorrect date. Changing it did help, but I still get dates in the pivot table fields. Now, they are _different_ dates, which is an improvement. Is there a formatting trick needed to simply get the 0's and 1's I need?

Thanks,
Art