sum(summary()) for groups with varying number of items
I have a matrix with groups of items for which I want to do sums. The groups have different numbers of items, so a category won’t work.
Currently, I create a single forumula for each group. Grp-Yr1.Total = sum(summary(Grp-Yr1)), Grp-Yr2.Total = sum(summary(Grp-Yr2)) etc. Overtime the number of formulas has increased as I’ve added new Groups of items. I’ve thought there should be a way to do this with a single formula. Well, this weekend I tried to do that, without success.
There’s probably a simple way to do this but I couldn’t find it. Does anyone have an answer.
Thanks in advance
The system wouldn’t allow my model to be uploaded so here’s an image of the matrix.
Hi lyledp, one way to solve this problem would be adding a new item to calculate cumulative values for each group with a single formula. Then you will not need sum summary items and formulas at all. Let me know if it would work for you, I can try to model it for you.