Pivot Table Calculations

S

Steve

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.
 
R

Roger Govier

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

Steve

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

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