My meagre GetSummary skills are unable to solve the following - here's how I'd like my report to look:

SUBSUMMARY CAT A CAT A VALUE CAT A XX%

subsummary total by sub-category A value XX%

subsummary total by sub-category B value XX%

subsummary total by sub-category C value XX%

subsummary total by sub-category D value XX%

SUB-CATEGORY TOTAL % 100%

SUBSUMMARY CAT B CAT B VALUE CAT B XX%

subsummary total by sub-category A value XX%

subsummary total by sub-category B value XX%

subsummary total by sub-category C value XX%

subsummary total by sub-category D value XX%

SUB-CATEGORY TOTAL % 100%

It's a pretty standard layout, I think.

What I'm really having difficulty with is getting that sub-category 100% to read - it's really just a visual check that what the report is showing is percentages *within* each subsummary.

The percentage calc within each subsummary is derived by a calculation field dividing the getsummary value for the sub-category by the getsummary value for the category.

I've tried every combination of summary fields and getsummary calcs in various places on the layout to add the sub-category percentages to show 100% but at this point I'm thrashing about and need to ask for direction.

Thanks in advance! Apologies if this has been covered here - my searches proved unfruitful!

Hi bdarch, and welcome to the Forum.

You don't indicate your skill level in FileMaker, so this may be a dumb question first.

Have you reviewed the sample files that came with FileMaker? There an Invoices.fp5 file that has a couple of reports that may be helpful to you.

You can also attach a copy of your files, which sometimes helps us zero in on the problem.

HTH

Lee