Consolidate Records With Totals

The Consolidate Records With Totals query loads records from the server for specified dimensions and value fields. the values of the table are consolidated depending on the filters and dimensions used in the query. The tuple of dimension-elements in each record of the resulting dataset is unique. Additionally, totals are build for the specified dimension-fields.

This example contains three dimensions (Region, KeyAccounter and Product) and one value-field (Amount). For Region and KeyAccounter totals and subtotals are build. The grandtotal is shown at the top.

Creating and Editing

It is recommended to use the Assistant to create a new Consolidate Records With Totals query. After creation the Fields and Totals can be edited.

See Also

• Consolidate Records With Total Properties