Pivot Table Average Summaries instead of Totals
With the new pivot table card designs we can add Totals and Sub Totals which is great and sums values into collapsable groups. I can't seem to see a way to set a similar summary using a different aggregation like average, count, min and max.
For example, I have data showing a number of staff working hours which are then grouped by managers. The current Total options can show there working hours summed but I require to show those as an average instead. Would anyone know of a way to do this in pivot table cards?
Many thanks in advance,