Jump to content
Sign in to follow this  
mtpaper

My Mind is stuck on sub-totals

Recommended Posts

Hello

I am trying to create a table in Filemaker. To wrap my head around the structure, I set it up in Excel. But I'm not experienced enough with Filemaker to understand how to create the layout, or if it's possible.

I know it's the Columnar Report Layout, but I'm all tangled with the sub-totals and what not....

I've attached my Excel file, the cvs data as well as the Filemaker table...

Can you look at it and sort me out?

Please excuse me if this is too much to ask for.

I have a feeling though, that it will be ridiculously simple for any of you pros, and, once I see what you've done, it will all make more sense to me.

Thank you-

Marion

Income_and_expenses.zip

Share this post


Link to post
Share on other sites

That's a good start for me, I think.... the thing is that I need to see [color:red]all the sub-totals that I've indicated on the xls file, via one report

Anyone up for that level of sub-totaling?

EDIT: ACTUALLY - THANK YOU!

IT WAS ENOUGH TO GET ME STARTED, and now I understand how it works! In other words, thanks for teaching me to fish, rather than giving me the fish.

Thank you! I'll be back if I have more questions!

Edited by Guest

Share this post


Link to post
Share on other sites

Ok. So I took what you showed me and have it working to a certain level that's real good (file attached)

However, I need to add 2 more pieces of info to this report, and I don't know how or if it's possible.

I have a field (not currently shown in the report) which indicates whether the expense is for Producer or Presenter.

I need the total for each to show, somewhere at the end.

Anyone up to take a stab at it?

I basically need, at the bottom, to see:

Producer share: $241,451

Presenter share: $193,055

Thanks -

Marion

EDIT: I decided what I wanted wasn't possible, because I was asking for 2 different sorts, in the same report. But I really appreciate the work you did - because I was struggling to get a handle on Part Layouts etc, and now I feel much more in control of the situation.

income_and_expenses_2.zip

Edited by Guest
self-education

Share this post


Link to post
Share on other sites

Now that I have a handle on seeing a report showing the detail and sub-totals, how do I go about creating a report that only shows the sub-totals???

Do I put the sub-total fields into the body section of the report?

Or do I make a body section that is super-skinny, with nothing in it?

Or is there another setting I need to toggle on?

Thank you -

Marion

Share this post


Link to post
Share on other sites

Leave the body out of the layout, i.e., delete it. Show sub-summaries & summaries plus header & footer.

Share this post


Link to post
Share on other sites

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
Sign in to follow this  

×

Important Information

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