Calculating the Product Sales Amount by Product Category and then by Product Name
Calculate the amount of product sales by product category and then by product name, and display the result as shown below.
Suppose that the form has the following fields:
- "Product category" field with the product category entered
- "Product name" field with the product names entered
- "Sales amount" field with the amount of product sales entered
-
On the app's "View" screen, click the Create Graph icon.
-
From Design a Graph Starting from Graph Type, click Column chart.
-
Specify each item.
- Chart Type
Select Column chart and Stacked. - Group by
Select "Product category" for Level 1 and "Product name" for Level 2. - Function
Select Sum and "Sales Amount."
- Chart Type
-
Click Apply.
The amount of sales is calculated and displayed in a graph.