Summarize a column in report with sum and average both | Community
Skip to main content
A
AnujTa
February 27, 2024
Solved

Summarize a column in report with sum and average both

  • February 27, 2024
  • 1 reply
  • 607 views

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. 

 

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by skyehansen

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.

1 reply

skyehansen
Community Advisor and Adobe Champion
skyehansenCommunity Advisor and Adobe ChampionAccepted solution
February 27, 2024

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.

Terms & ConditionsAccessibility statement

Loading footer...