Calculated fields in Pivot Tables

  • Thread starter Thread starter lj
  • Start date Start date
L

lj

Is it possible to use an "if" formula when creating a calculated field?
I have an existing field in my pivot table called commissions and I
want to create a new field that will give me a 1 if for each row if
commissions are over 4 and a 0 if they are under 4. Is this possible?
What is the formula?
 
Try something like : =IF(Commissions>=4,1,0)

The above formula is inserted within the "Insert Calculated Field" dialog
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table calculated field Count(field) / sum(field) 0
Help creating a sales commission formula 3
Pivot table calculated field: multiply Sum of FieldA with Max ofFieldB 4
pivot table calculated field 1
Copy calculated field 1
Pivot Table Question. 1
Turning Data into a Table 1
Pivot Table Help! 1

Back
Top