mtpaper Posted May 1, 2009 Share Posted May 1, 2009 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 Link to comment Share on other sites More sharing options...
Matthew F Posted May 1, 2009 Share Posted May 1, 2009 Maybe something like this? income_and_expenses.fp7.zip Link to comment Share on other sites More sharing options...
mtpaper Posted May 1, 2009 Author Share Posted May 1, 2009 (edited) 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 Link to comment Share on other sites More sharing options...
mtpaper Posted May 2, 2009 Author Share Posted May 2, 2009 (edited) 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 Link to comment Share on other sites More sharing options...
mtpaper Posted May 3, 2009 Author Share Posted May 3, 2009 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 Link to comment Share on other sites More sharing options...
RalphL Posted May 3, 2009 Share Posted May 3, 2009 Leave the body out of the layout, i.e., delete it. Show sub-summaries & summaries plus header & footer. Link to comment Share on other sites More sharing options...
mtpaper Posted May 3, 2009 Author Share Posted May 3, 2009 Thank you - Love when it's that simple Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5471 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 accountSign in
Already have an account? Sign in here.
Sign In Now