I am trying to add a countif formula to my Zoho CRM Analytics table that is pulling from my CRM nightly.

I have built the aggregate formula but the formula itself  is calculating based as whole on the table.

 

How can  I build the formula so that is performs the calculation on each record.

For Example: countif date > 7/1/2012

 

I would need to perform the calculation for each record and place a 1 if that record meets the criteria.

Currently it is looking at the entire table and telling me how many meet that.

 

When using this field in a pivot and I pivot other criteria it does not have the correct number.