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