Jump to content

Subsummary calcs


bdarch
 Share

This topic is 5772 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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! :P Apologies if this has been covered here - my searches proved unfruitful!

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 5772 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

  • Who Viewed the Topic

    2 members have viewed this topic:
    siroos12  jjjjp 
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.