4.8 Creating Summary Data Tables in a Query

The previous section showed how you can create new columns that summarize all the rows belonging to a group. The summarized values were repeated for each row that belonged to the group. But if you want only one row for each group showing just the summarized values, you can do this in a query by eliminating all columns that are not either grouped or summarized.

Here is a sample of the AdResults data that contains the amounts spent on advertising for the Fire and Ice Tours company for its Seattle and Portland offices. This example creates a new table with two rows showing the total number of bookings and amount spent by each office. To open the Query Builder, click the data icon in the Project Tree or Process Flow to make it active, and select Tasks Data Query Builder from the menu bar.