Walkthrough: Grouping and Summary in Data Binding Wizard

Walkthrough

This example is continued from the previous example, Walkthrough: Adding Conditions in Data Binding Wizard.

1. In the 'Data Binding' dialog box, select the Grouping & Summary tab. (See Creating a New Table, Crosstab, or Section using a Wizard for information on how to access the 'Data Binding' dialog box.)

2. Drag the 'Customer.Company' field from the 'Available Columns' panel to the 'Grouping' panel.

3. Drag the 'Product.Name' field from the 'Available Columns' panel to the 'Grouping' panel. Drop it below 'Customer.Company'.

4. Drag the 'TotalDiscount' field from the 'Available Columns' panel to the 'Summary' panel.

 

5. In the 'Grouping' panel, select 'Product.Name' and click the Top N tab.

6. Select 'Top' from the drop-down list, enter “3” for the number of groups, and select 'Sum(TotalDiscount)' from the second list.

 

7. Click 'Finish' to complete the data binding.

8. Click 'Preview' in the Style Studio toolbar. When prompted, enter “10” for the 'minimum order size' filter parameter.

Notice how the data now displays only records with quantities greater than or equal to 10, and where the customer company was either 'Computer Tech' or 'Eastern Data'. Additionally, the data only displays records for the top three products based on summarized total.

<< Summarization Formulas © 1996-2013 InetSoft Technology Corporation (v11.4) 6.2.6 Data Binding Options >>