PivotTables: "Summarize by" does not work

%3CLINGO-SUB%20id%3D%22lingo-sub-2155324%22%20slang%3D%22en-US%22%3EPivotTables%3A%20%22Summarize%20by%22%20does%20not%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2155324%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20community%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20got%20a%20problem%20with%20my%20PivotTable%20I'm%20using.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20got%20multiple%20columns%20which%20all%20contains%20percentages.%20The%20subtotals%20and%20totals%20of%20these%20columns%20are%20showing%20averages.%20But%2C%20I%20got%20two%20other%20columns%20with%20absolute%20numbers%20which%20are%20summarized%20by%20sum%20even%20though%20I%20switched%20them%20in%20%22field%20option%22%20to%20average.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%20everything%20and%20searched%20hours%20in%20order%20to%20solve%20this%20problem.%20Is%20there%20anyone%20who%20has%20experienced%26nbsp%3B%20something%20like%20that%20or%20could%20help%20me%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2155324%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hello community,

 

I've got a problem with my PivotTable I'm using.

 

I've got multiple columns which all contains percentages. The subtotals and totals of these columns are showing averages. But, I got two other columns with absolute numbers which are summarized by sum even though I switched them in "field option" to average.

 

I tried everything and searched hours in order to solve this problem. Is there anyone who has experienced  something like that or could help me?

 

Thanks in advance.

1 Reply
Hi..

could it be possible to attach the sample file to have look

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
If you find the above solution resolved your query don't forget mark as Official/Best Answer & like it to help the other members find it more.