1 of 1 people found this helpful
It sounds like it is not calculating based on the subsummary, but on totals. If you can post your file it would be easier to find the problem.
I don't know that I would base that calculation on a Summary, but instead on relationships that way you can hold it to just that table.
If I understand correctly, I think you can get there with straight-forward summary fields.
Sum_TableTotal = Total of FoodCost
Sum_IndShare = Average of FoodCost
Put both fields in subsummary part sorted by Table.
Craig: Your solution worked perfectly! I don’t know why I didn’t try another summary field beings the first two worked as expected, but thanks much for picking up on it so quickly and getting me back on track.
DigitalCarpenter: Thanks for the insight: I've never tried to use multiple relationships to further define my record set - from what I can gather, they act like super-strength finds, but at my current level (Noobius Extremus), I can't figure out the second relationship: The first relationship is the Primary Key to Foreign Key, but what could I use for the further defining relationship? This approach would give me a Universal solutiojn that I could use in many cases and a Strategic answer is usually more flexible that a tactical answer. I'd sure appreciate any thoughts you might have?
p.s. The panoramas on your web site are awesome! Thanks for sharing those as well!