Group and calculate data on columns
Summary
Data views allow groupings and links on columns.
Group data
To group data you must select the option Group by columns
You should select and add the columns on which the group would apply. Initial values would be grouped together.
Once the columns by which to group have been defined, the option of calculations would be enabled.
You may select the operation (count, add or average), the column on which the operation would be applied and the name or item to be taken.
Once the settings have been made, you could view and edit them.
In the revision step, the outcome of the group and clustered links.