Home

Pivot Table Calculated Item and Calculated Field

%3CLINGO-SUB%20id%3D%22lingo-sub-328023%22%20slang%3D%22en-US%22%3EPivot%20Table%20Calculated%20Item%20and%20Calculated%20Field%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-328023%22%20slang%3D%22en-US%22%3E%3CP%3EIf%20you're%20not%20sure%20how%20to%20use%20Excel's%20pivot%20table%20formulas%20(calculated%20items%20and%20calculated%20fields)%2C%20I've%20made%20a%20short%20video%20that%20shows%20how%20they%20work.%3C%2FP%3E%0A%3CP%3ESee%20how%20to%20set%20up%20simple%20formulas%2C%20and%20then%20use%20a%20built-in%20command%20to%20quickly%20create%20a%20list%20of%20all%20the%20pivot%20table%20formulas.%3C%2FP%3E%0A%3CP%3ESee%20%3CA%20title%3D%22Pivot%20Table%20Calculated%20Item%20and%20Calculated%20Field%22%20href%3D%22https%3A%2F%2Fwww.pivot-table.com%2F2019%2F01%2F30%2Fcreate-pivot-table-calculated-item-and-calculated-field%2F%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ethe%20video%2C%20and%20more%20details%20on%20pivot%20table%20formulas%3C%2FA%3E%2C%20in%20my%20Pivot%20Table%20blog.%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3ENOTE%3C%2FSTRONG%3E%3A%20These%20formulas%20are%20not%20available%20for%20pivot%20tables%20based%20on%20the%20Data%20Model.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%22%20style%3D%22width%3A%20307px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F71455i53F3E43A536D3291%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22calcitemcalcfield01.png%22%20title%3D%22calcitemcalcfield01.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-328023%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ETips%20and%20Tricks%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Debra Dalgleish
MVP

If you're not sure how to use Excel's pivot table formulas (calculated items and calculated fields), I've made a short video that shows how they work.

See how to set up simple formulas, and then use a built-in command to quickly create a list of all the pivot table formulas.

See the video, and more details on pivot table formulas, in my Pivot Table blog.

NOTE: These formulas are not available for pivot tables based on the Data Model.

 

calcitemcalcfield01.png

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies