AnsweredAssumed Answered

Calculating Sub-Totals from 3 Summaries

Question asked by mora_1 on Mar 15, 2012
Latest reply on Mar 16, 2012 by mora_1

Title

Calculating Sub-Totals from 3 Summaries

Post

Hi

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?

 

Example:

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?

Outcomes