Wondered if there was a way - using a pivot table - to get the average after doing a count.
Example:
Row Labels Average of Age Count of Owner
Bill 39 5
Charlie 17 15
Sam 16 17
Alex 17 10
John 18 6
Jim 1 1
Grand Total 19 54
I'd like to have the total show the average of the owners and not the count - is that possible?
Example:
Row Labels Average of Age Count of Owner
Bill 39 5
Charlie 17 15
Sam 16 17
Alex 17 10
John 18 6
Jim 1 1
Grand Total 19 54
I'd like to have the total show the average of the owners and not the count - is that possible?
Last edited: