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
Highlighted
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
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies