Summarize a column in report with sum and average both

[AnujTa]

Hi- Is there a way to summarize a column in report with sum and average both? Average value at sub-grouping (child) level and then sum of all sub-grouping level at group (parent) level. Basically, average of all the numbers which are under subgroup and then sum of all the subgroup numbers which are under group at group level. 

For e.g. 

[skyehansen · Accepted solution]

you could add the column twice and then make one the sum column and the other the average column, but there's not a way to do both to the same column.