Expand my Community achievements bar.

The next phase for Workfront Community ideas is coming soon. Learn all about it in our blog!
SOLVED

Summarize a column in report with sum and average both

Avatar

Level 1

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. 

 

AnujTa_0-1709021442466.png

 

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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.

View solution in original post

1 Reply

Avatar

Correct answer by
Community Advisor

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.