Home

More summary columns in a pivot table?

%3CLINGO-SUB%20id%3D%22lingo-sub-575113%22%20slang%3D%22en-US%22%3EMore%20summary%20columns%20in%20a%20pivot%20table%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-575113%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20community%2C%3C%2FP%3E%3CP%3EI%20have%20a%20pivot%20table%20with%20the%20summary%20of%20the%20columns%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F113731i4DB534A439A1AFDC%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%222019-05-16%2016_24_08-Pivot%20testdata%20en.xlsx%20-%20Gespeichert.png%22%20title%3D%222019-05-16%2016_24_08-Pivot%20testdata%20en.xlsx%20-%20Gespeichert.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThe%20problem%20is%2C%20that%20he%20calculate%20all%20columns%20(effort%20and%20cost%2C%20lan%20and%20actual)%20in%20one%20value.%3C%2FP%3E%3CP%3EI%20need%20this%20in%20separate%20columns%2C%20separete%20in%20plan%2C%20actual%2C%20separate%20in%20effort%20and%20cost.%20Here%20I%20have%20a%20faked%20pivot-table%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F113732i1470A39BA45DC5C7%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%222019-05-16%2016_28_04-Pivot%20testdata%20en.xlsx%20-%20Gespeichert.png%22%20title%3D%222019-05-16%2016_28_04-Pivot%20testdata%20en.xlsx%20-%20Gespeichert.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EHow%20can%20I%20do%20this%3F%3C%2FP%3E%3CP%3EI%20have%20attached%20the%20original%20excel%20file.%3C%2FP%3E%3CP%3EThank%20you%20very%20much!%3C%2FP%3E%3CP%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%20Michael%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-575113%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
MMF200
Occasional Visitor

Hello community,

I have a pivot table with the summary of the columns:

2019-05-16 16_24_08-Pivot testdata en.xlsx - Gespeichert.png

The problem is, that he calculate all columns (effort and cost, lan and actual) in one value.

I need this in separate columns, separete in plan, actual, separate in effort and cost. Here I have a faked pivot-table:

2019-05-16 16_28_04-Pivot testdata en.xlsx - Gespeichert.png

How can I do this?

I have attached the original excel file.

Thank you very much!

    Michael

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 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
28 Replies
description for autoplay blocking in settings page
HotCakeX in Discussions on
8 Replies