SuperQuery Table View contains several panes separated by Splitters. As you are scrolling in the Data Table pane, all other panes in the same view are updated at all times. You can completely reconfigure any view by including some or all pane types.

• Click on the "Sales Data" tab. Move the cursor through the columns, and look at the Reps Graph to see the most common values in each column.
• Go to a numerical column "PROFITDLR" or "QTYSOLD" and look at the Total Page pane to see the total, average, minimum and maximum values.
• Click on any cell in the "CITY" column. The Reps Graph pane will show the most common values in this column. Double click on the "New York" bar in the graph. SuperQuery will immediately position the cursor in the Data Table at the first row that has the value "CITY = New York". Now push the filter button, and you will see only those rows satisfying that value "CITY = New York". Scroll through the other columns and watch all graphs and statistics calculated for New York. Furthermore, move to the "Profit" column and place the cursor on any cell having the value "High" then press the button again. This will simply perform the Query "City = New York AND Profit = High". This means that you are only viewing sales in New York City, which has high profits.

As you may have noticed, both "Profit" and "Quantity" columns have the cyan color, to reflect that they are calculated by the system. The Analysis Wizard created these two columns when you were reading the data table.

In order to edit the "Profit" column; first make sure that no filters are set on the view. To release all filters, press on the button, so that the green light is turned off. Double click on the column "Profit", the "Enter Ranges" dialog is displayed. Click on "5 Range" button and press OK. The column will be recalculated to map the original numerical values into five ranges (Very High, High, Medium, Low and Very Low) instead of three ranges (High, Medium, and Low).

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

1. Place the cursor on the column " CITY" and press the button. The Add / Edit Virtual Columns dialog is displayed. Type the new column name "NY Winter Sales" in the "Select / Add column" edit box. Press on the "Filter" button. The "Enter Criteria" dialog is displayed.

2. To create the first part of the criteria "CITY = New York" double click on the cyan cell next to "CITY", the Enter Criterion dialog is displayed.

3. Click on the drop-down box to select the operator "to return back to the "Enter Criteria" dialog.=". Select the value "New York. Press OK

4. In order to AND another criterion, simply double click on any other cyan cell in the same column that has the previous criterion you created. On the other hand, if you want to OR ANOTHER criterion, double click on any other cyan cell in the same ROW. Now to AND the second part of the criteria "MONTH is one of (December, January and February)", double click on the cell next to the "MONTH", again the "Enter Criterion" dialog is displayed.

5. Click on the drop-down box to select the operator " is one of". Select the values "December, January and February" from the list and press OK. The Enter Criteria dialog will show the criterion " is one of (December, January and February)" in the cell next to the "MONTH". Press OK to return back to the Enter Criteria dialog. Press OK.

6. SuperQuery will create the new column "NY Winter Sales" and add it to the view before the "CITY" column. The new column will be given a cyan color indicating that the column is a calculated column (Virtual Column).

On the graph double click on the "True", the cursor will be placed on the first value equal to "True" in the "NY Winter Sales" column. Press the filter button to show only the values satisfying the criteria. Now move the cursor on the column "QTYSOLD" and "PROFITDLR" and study the statistics of each column from the "Total page" pane.

• Chapter 1 -- Getting Started in SuperQuery
• Chapter 2 -- Organizing your Data
• Chapter 3 -- Querying the Database ( Classification Column) (Filter Column)
• Chapter 4 -- Discover Facts and Rules (Office edition) (Discovery edition)
• Chapter 5 -- Summarize your data