Pivot Tables - Using "IF" function in calculated fields

P

pjalan

Hi

I tried using an "IF" function in a calculated field of a pivot table,
to return different text values based one of the summarised base
fields in the pivot table. Am getting "#VALUE!" in the cells of the
calculated field column.

How do we use "IF" functions in a calculated filed?

Thanks
Pawan
 

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

Slicers and Calculated Items in Pivot Table 2
Dealing with a Pivot Table (when I don't want to) 0
Excel does not accept text format! 0
Additional columns for Pivot table 0
Pivot table 0
Pivot Table cell values 1
Problem inserting calculated pivot fields into Pivot Table (2007) 1
how do I remove #DIV/0! in a pivot table calculation field ? 2

Top