Calculated field in pivot table is used to create a new
field with user-defined calculations. And, currently we can do simple
arithmetic operations alone. But, this feature allows the user to do logical
calculations by using conditional statement in the formula field of calculated
Example: if(x=0,0, (x-y)/x)
(Last updated on: June 24, 2019).