Skip to main content
I want my custom report to be able to get the average of a certain number field, show the average result on the 3rd level of my grouping and then be able to sum up all the result of that grouping and show it on the 2nd level of my grouping. Is this possible?
25 件の回答
  1. 2013年6月4日 0:51
    SteveMo,

     

    I can already get the Average that I want from a group. What I want to do is to be able to sum up those averages that belong to the second group. In my mock-up picture I want to have the last column stroked in red.

     

    SteveMo, I can already get the Average that I want from a group. What I want to do is to be able to sum up those averages that belong to the second group.

     

    Jeff,

     

    Thank you for your input. I do not really have any business case for getting the Sum of the Averages that I get for the 3rd group level, I just need to sum them up. I don't relly know how I could explain it, but Mathematically I know what the averages should be for each group, I am also using filters on my report template so that I would always get the same ave for each group.

     

    By the way, I am using Contact Manager Edition and is using this not to manage Sales but to manage our Manufacturing process, hence my mock-up contains job orders.