SOLVED
Home

Pivot tables - calculated fields

%3CLINGO-SUB%20id%3D%22lingo-sub-694106%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20tables%20-%20calculated%20fields%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-694106%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F360755%22%20target%3D%22_blank%22%3E%40MANDEEP3122%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ERight%20click%20on%20Table1%20in%20PivotTable%20Fields%20and%20Add%20measure%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20324px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F118186iDBB51FFC4C87E0DB%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EName%20it%20Rate1%20and%20start%20typing%20formula%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20558px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F118187iC15FF1C88BAB505C%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3ESelect%20proper%20fields%2C%20finally%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20365px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F118188i731A202F8E894F92%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3ESame%20for%20Table2%20and%20Rate2.%20Add%20created%20measures%20to%20PivotTable.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20343px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F118189i11E72C5CBDE6E596%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EPlease%20check%20attached.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-694142%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20tables%20-%20calculated%20fields%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-694142%22%20slang%3D%22en-US%22%3E%3CP%3Ethanks%20for%20you%20early%20action%2C%20but%20when%20i%20click%20right%2C%20then%20add%20measure%20option%20is%20not%20available.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-694145%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20tables%20-%20calculated%20fields%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-694145%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F360755%22%20target%3D%22_blank%22%3E%40MANDEEP3122%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDo%20you%20click%20here%3F%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20359px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F118190iF016E3E640FE6E1B%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-694146%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20tables%20-%20calculated%20fields%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-694146%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3Byes%2C%20but%20not%20showing%20add%20measure%2C%20but%20showing%20remove%20from%20active%20tab%2C%20screen%20shot%20is%20attached%20herewith%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-694147%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20tables%20-%20calculated%20fields%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-694147%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F360755%22%20target%3D%22_blank%22%3E%40MANDEEP3122%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EOn%20which%20version%20of%20Excel%20you%20are%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-694148%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20tables%20-%20calculated%20fields%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-694148%22%20slang%3D%22en-US%22%3Eexcel%202013%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-694149%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20tables%20-%20calculated%20fields%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-694149%22%20slang%3D%22en-US%22%3E-%40sergei%20baklan%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-694150%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20tables%20-%20calculated%20fields%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-694150%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F360755%22%20target%3D%22_blank%22%3E%40MANDEEP3122%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20see%2C%20it%20was%20removed%20for%202013.%20If%20you%20are%20on%20Pro%20Plus%20you%20may%20activate%20Power%20Pivot%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fstart-the-power-pivot-add-in-for-excel-a891a66d-36e3-43fc-81e8-fc4798f39ea8%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fstart-the-power-pivot-add-in-for-excel-a891a66d-36e3-43fc-81e8-fc4798f39ea8%3C%2FA%3E%26nbsp%3Bto%20work%20with%20measures.%20If%20not%20-%20not%20sure%20what%20to%20do.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-694151%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20tables%20-%20calculated%20fields%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-694151%22%20slang%3D%22en-US%22%3Eok%20sir%2C%20thanks%20for%20your%20time%20and%20early%20reply%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-693985%22%20slang%3D%22en-US%22%3EPivot%20tables%20-%20calculated%20fields%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-693985%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20to%20add%20calculated%20field%20in%20consolidated%20pivot%20table%2C%20not%20in%20standard%20pivot%20table%20i.e(rate%3Dvalue%2Fqty)%20in%20column%20as%20i%20have%20shown%20in%20attached%20excel%20sheets%20rate1%20%26amp%3B%20rate2%20which%20i%20have%20calculated%20manually%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-693985%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analytics%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Econsolidated%20pivot%20table%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
MANDEEP3122
Occasional Contributor

I want to add calculated field in consolidated pivot table, not in standard pivot table i.e(rate=value/qty) in column as i have shown in attached excel sheets rate1 & rate2 which i have calculated manually

9 Replies
Solution

@MANDEEP3122 

 

Right click on Table1 in PivotTable Fields and Add measure

image.png

Name it Rate1 and start typing formula

image.png

Select proper fields, finally

image.png

Same for Table2 and Rate2. Add created measures to PivotTable.

image.png

Please check attached.

thanks for you early action, but when i click right, then add measure option is not available.

@MANDEEP3122 

Do you click here?

image.png

 

@Sergei Baklan yes, but not showing add measure, but showing remove from active tab, screen shot is attached herewith

@MANDEEP3122 

On which version of Excel you are?

excel 2013
-@sergei baklan

@MANDEEP3122 

 

I see, it was removed for 2013. If you are on Pro Plus you may activate Power Pivot https://support.office.com/en-us/article/start-the-power-pivot-add-in-for-excel-a891a66d-36e3-43fc-8... to work with measures. If not - not sure what to do.

ok sir, thanks for your time and early reply
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies