My Mind is stuck on sub-totals

[mtpaper]

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

[Matthew F]

Maybe something like this?

income_and_expenses.fp7.zip

[mtpaper]

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 May 1, 2009 by Guest

[mtpaper]

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 May 3, 2009 by Guest
self-education

[mtpaper]

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

[RalphL]

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

[mtpaper]

Thank you -

Love when it's that simple