Can you use IF function in pivot tables?

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

Guest

I was wondering if the IF or IIF statement could be used in pivot table
calculated fields/items? Any help/insight would be great.

Thanks.
 
Hi Steve,
this maybe an odd suggestion. If the pivot will not be used as a filtering
table but rather a presentation report, in my case, i may feel convenient to
place the if formulas not in the pivot's calculated field but rather in the
adjoining column that will not be within the reach of the pivot table range
values automation. In this independent column, you may add more color coded
conditional formatting for your further nesting of validation requirements.

regards,
driller
 
I wish I could do this but the calculation needs to be between certain
columns within the pivot table. Thanks.
 
You must log in or register to reply here.

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 with Data Model Connection - getpivotdata reference issue 0
Average of Subtotals in Pivot Table 0
N/A in pivot table become 0 1
Calculate # days from today in a Pivot Table 10
Pre-configuring Pivot table "views" 4
Calculated Item in Pivot table 1
2007 Pivot table Calculated field misbehaving 1
Pivot table for worksheet text fields? 2

Back
Top