Calculating the Product Sales Amount by Product Category and then by Product Name

Article Number:040757

Calculate the amount of product sales by product category and then by product name, and display the result as shown below. Screenshot: A bar graph showing the total sales of products

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
  1. On the app's "View" screen, click the Create Graph icon. Screenshot: The "Create Graph" icon is outlined

  2. From Design a Graph Starting from Graph Type, click Column chart.

  3. 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." Screenshot: The settings under "Graph Options"
  4. Click Apply.
    The amount of sales is calculated and displayed in a graph.