Appearance
Consolidate Records
The Consolidate Records 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.
This example contains two dimensions (Year and Product) and four value-fields (Amount, TurnoverTotal, CostsTotal and ProfitTotal).
Creating and Editing
It is recommended to use the Assistant to create a new Consolidate Records query. After creation, the Fields can be edited.