Pivot table - Count of numbers above 0

[phitho]

I've created a pivot table that has 3 columns: User, CreationDate, TargetDate.

TargetDate has negative, 0, and positive numbers.

I am trying to build a pivot table that will show the count of numbers greater than 0, and for a particular month of the year. When I do this, the pivot table does not appear to be filtering the dates and is returning the count of all fields greater than 0.

For example, if I have 71 rows greater than 0, but only 6 for the month of August, the pivot table returns 71.

What is going on??

 

[tcardwell]

Are the CreationDate and TargetDate real date fields?

 

[phitho]

CreationDate is a date field, and TargetDate is a number (-5, -1, 0, 225, etc). What I want to do is in TargetDate keep all numbers >0 and have all other numbers be null.

 

[tcardwell]

Assuming User is the leftmost column, right click anywhere on a user and then select filter from the submenu. From here you can filter on the targetdate to only show number greater than zero.