Calculating Sub-Totals from 3 Summaries
I am very new to FMP and databases, and am on FMP Pro 11. Can someone please help me get a sub total from 3 summaries created in a report.
There are different products, and each product have different types of sales.
Example of Product Field records = table cloth, dinner napkins, table runners
Sales has 3 fields = Direct Sales, Commission Sales, Referred Sales.
I have created a report that summarizes the different sales for each product. How do I get a sub-total sales for each product?
Table Cloth Summary: Direct sales = $1200, Commission Sales = $600, Referred Sales = $500. How do I get sub-total sales for Table Cloth?
Curtains Summary: Direct sales = $2000, Commission Sales = $800, Referred Sales = $400. How do I get sub-total sales for Curtains?