I need to show average values in the "total" row at the bottom by each column.
I've got a pivot table with two dimensions (one of them are calculated). I selected a "show partial sums" option to my calculated dimension so the "total" row appeared but the values were strange. How to show average values? Screenshot is attached.