
25 件の回答

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.
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.