IF Conditions in Pivot Table Calculated Field

[bobsri]

Can we use If conditions in Pivot table Calculated field...

 

[NARAYANK991]

Hi ,


Check out this :


http://www.excelforum.com/excel-formulas-and-functions/533235-can-i-use-if-function-in-calculated-fields-in-a-pivot-table.html


As long as your IF statement uses numeric fields , it should work ; if it uses text fields , it will not work.


Narayan


One more link :


http://www.contextures.com/excel-pivot-table-calculated-field.html

 

[SirJB7]

Hi, bobsri!

Regarding PT calculated fields, sometimes happen annoying things like this a few days ago. Still unresolved:

http://chandoo.org/forums/topic/pivot-table-and-calculated-field

Regards!