Hi, I have the following pivot table
I want to add a singe column, after the "grand total" column (and just that single column) to calculate averages (so for xxx the average would be =average(62,75,66.....85) automatically, as columns will be added to the row labels with time .
Note that the values (62, 75 etc.) are "count" values and not "sum" values. if this matters.
is this possible? any help will be great.
Also, this is for excel, but if someone knows also the google sheet solution for this (as i am working on both), that would be amazing. Thanks!!
I want to add a singe column, after the "grand total" column (and just that single column) to calculate averages (so for xxx the average would be =average(62,75,66.....85) automatically, as columns will be added to the row labels with time .
Note that the values (62, 75 etc.) are "count" values and not "sum" values. if this matters.
is this possible? any help will be great.
Also, this is for excel, but if someone knows also the google sheet solution for this (as i am working on both), that would be amazing. Thanks!!
