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.

Hi Steve
What are your field labels
What is the formula you are using within the PT?

--
Regards

Roger Govier


"Steve" wrote in message
...
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.

The fields are State and Sales with the formula as follows:

=IF('State'="Florida",'Sales'*.5,'Sales'*.45)

"Roger Govier" wrote:

Hi Steve
What are your field labels
What is the formula you are using within the PT?

--
Regards

Roger Govier


"Steve" wrote in message
...
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.