Feb 22 2021 02:39 AM
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.
Feb 27 2021 05:12 AM