Be sure you are including the Division field value in the sort order for the records, and that you have a sub-summary part set to break when sorts by that field. Then check that your total field is full contained within that sub-summary part. You should be able to use the same total field which is used in other sub-summary parts; which part it is placed within determines which sub-sum it shows in each part.
Thanks for the reply but everything is where it should be. All data shows up correctly except for the related fields totals. I have added a pdf of what I am seeing to the original post.
Another thing you need to check is the order in which the sort occurs; it needs to be in an "inside out" order to give all the correct subtotals.
The pdf doesn't help much.
Can you show is the actual sort order, per Keywords' comment?
The pdf addresses Stephens original remarks. The sort order is 1-Division, 2-Marketing Rep.
The report is:
SS by Division leading
SS by Marketing Rep trailing
SS by Division trailing
Try working on a copy of the layout and respace the sub-sum parts to be taller, and be sure the fields are at least a couple of pixels from any part's top-or-bottom edges.
The failure of the parts' totals to appear makes me think they are touching, hanging, or crossing from one part to another. That was allowed in some earlier versions, but not anymore due to the CSS-based layout rendering system.
Thanks and I hear you, I've been through that before. Have already increased the layout with no positive result. All the amount fields are the exact same size and lined up. Also, how can the totals for the "local" table be correct and not the related table? Feels like I'm missing something really simple.
Feels like I'm missing something really simple.
That may well be, but it's hard to tell from just a PDF of the result and a description of the part setup. Maybe post a copy of your file with some sample and/or anonymized data?
This morning I realized that the summary fields that totaled the related Goal data were not using a relationship based on Division, so it would not separate the sub summaries. Just added that relationship and the totals all work now. Knew it would be something simple. Thanks for all the input.
Yep, mismatched TOs for the layout's base table are a real stinker, and hard to spot in complex graphs. Sometimes rebuilding the layout, or repointing each field on the layout, is the only way to spot that error.