I can use the IF function in pivot table calculations if I my logical test is
based off the DATA being summed, however, if I try to use a field in the ROW
section of the pivot table, it does not work. For example, if I want to test
a field called "States" for any Florida results, then put a value in the
calculated field, it does not work properly. All it does is put the false
value for all states including Florida. What am I doing wrong or is this
possible?

Note - I cannot put the value in the raw data.

Thanks.