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?
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.