PivotTables: "Summarize by" does not work

Copper Contributor

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.