This is probably a straight forward question, but I'm trying to figure out how to get parent summary info on a child sub-summary layout. In this relationship I have a straight forward parent --> child. In the layout, I have the following part layout:
Regional sub summary section
Parent sub summary section
Obviously, any data I pull from the parent and put into the parent sub summary section works because of the relationship. But, I now need to put summarized parent info into the regional sub summary section where several parent records need to be summed up. When I've tried this, I get either the parent value for the first child record occurrence, or a total of each parent record multiple by the number of child records. How can I get just the parent summary info?
The layout needs to be on the child table; it won't really work with a portal from the parent record (there are an unlimited # of child records for each parent).