Field Groups

Groups are a specific kind of filters that do not affect the whole consolidation query but only the selected field. Groups can be edited in the field-list or the inspector.

Add an Item

To add an item a dimension must be selected.

When the Items tab is active, an item can be dragged into the grouping area. In this sample the North item of the Region dimension is used.

Add a Tree Item

Trees can be used for grouping. Therefor the Trees tab must be selected. In this sample the ABC tree of the Customer dimension is selected.

The sums and items of the selected tree can be dragged into the grouping area. In this sample the A customers are used.

Add a Filter

When the Filters tab is active, a filter of the workspace can be dragged into the grouping area. In this sample the FilterProductType is added.

Finish

After finish, the selected field has three Groups.