February 15, 200521 yr Ok i have built a billing sheet table. one of my fields is rep (which pertains to sales person) I want to make a calc on my monthly stats page that will add the amount field to the specific name only. I tried carol=repp + amount but it does not work I want to be able to tell filemaker that the amount in this record should be added to a total for this rep. Plz some small help would be great!
February 15, 200521 yr This sounds like a good place to use a summary field that totals in a Sub-summary part of a layout. You find a records for the month sort them by sales rep and print your report. If you just want the totals without details remove the body part of the layout. Use a Columnar list/report type layout.
Create an account or sign in to comment