AZMY
Thinkware, Inc		 General Order FormSupport CenterSearch this web siteAbout Azmy
Summarize your data    
    Suppose that you want to analyze your sales by product. For example, for each product, you want to know:
  • The most common city and month in sales,
  • The total quantity sold, and
  • The total profit.

Now click on the first tab "Sales Data" in order to work again with the Sales data view. Make sure that no filters are set on the view. To release all filters, press on the filter button so that the green light is turned off.

On the sales view, press the summary button; the Add / Edit Summary table dialog is displayed
     
     
    In the Select / Add Summary Table edit box, write down "Product Summary" to name the new Summary table. Click on the "Group By" drop down box to select the PRODUCT column. Press the "Select Cols" button in order to select the columns City, Month, QTYSOLD and PROFITDLR and their associated summary operators. The "Select columns and their summary calculations" dialog is displayed.
     
     
    Check the boxes next to the columns: City, Month, QTYSOLD and PROFITDLR. Click on the drob-down box next to the "CITY", and select the operator "Most common". Also for the "MONTH", select the operator "Most common". For both "QTYSOLD" and "PROFITDLR", select the operator "Total". Press OK to return back to the Add / Edit Summary Table dialog and press OK.

SuperQuery will summarize the data on each of the products: Coat, Glove, Hat, Jacket and Shirt and will show them in a new Summary view.
     
     
    The new view will be floating on the top of the data view. Move this view to third tab "Product Summary". To do this, click on the "Product Summary" tab. The view will move to this tab. Press on the button to fix the view in this tab.

The first row in the summary view reveals the following :

  1. Boston is the most common city in coat sales.
  2. December is the most common month in coats sales.
  3. The total quantity sold for coats are 7260.
  4. The total profit for selling coats are $13150.

In order to view those rows that have "PRODUCT = Coat", place the cursor on the first row and click on the Drill-Down button. SuperQuery will create a new data view and set a filter on those data rows. You can close the view or move it to another tab.

The Data Graph is showing the values of the column you have the cursor on. In this case, the graph is showing the values of the column "Total QTYSOLD". It is clear that Shirts are the highest quantity sold since they have the longest bar in the graph. You can set the Graph Pane to show the highest or lowest values using its property menu.

Browse through the summary view rows and columns and look at the Data Graph and experiment with

   

 

Copyright © 1996 - 2007 AZMY Thinkware Inc. All rights reserved.