I am trying to add a calculated field into a pivot table on sheet 2 that will count the number of 'Issue' (s) that have the criteria "NEEDS FOLLOW UP"
when I use the formula below excel says, "This formula contains an error"
=COUNTIF(ISSUE,"NEEDS FOLLOW UP")
I tried the formula below in the pivot table source data sheet "SERVICE REQUEST" in cell J1 and it works
=COUNTIF(C:C,"NEEDS FOLLOW UP")
I realize i could add a column in the source data to put a 1 if it "needs follow up" and a 0 if it is anything else, but I do not want to add to the source data.
Is there a way to do this in a calculated field or is it not possible?
Bookmarks