hallpett
asked on
Pivot, Calculation on Column field
Take a look at the image below. Is it possible to make the difference calculation I have done in column F as a calculated field inside the Pivot? So that the difference field workes like a part of the Pivot. Appreciate any replys.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Make pivot table in regular way. then click on the Pivot table and in Ribbon choose Analyze from Pivot Tools. Then Fields, Items, Sets and Calculated Item:
Name your field and make a calculation you need to do: