Pivot Table Calculations

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
The fields are State and Sales with the formula as follows:

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