Grouping Categories
The example below shows all columns with generated data within the Data Performance Table without Grouping.
To generate a select number of columns for data you must use the Group by Columns.
Choose a selected number from the drop-down for example 1,2 this will then generate data for the first and second columns.
Depending on what category of data you require you can rearrange the columns by dragging and dropping them into place.
To group any data first choose how many columns you wish to group by using the Column Group Count field.
To begin creating a group choose which header you want to group by, in this example it’s SHOP.
NOTE: If the Column Header you require is not shown in the Data Performance Table you can use the Column Chooser button to select and deselect different Headers.
Click and hold the Shop header and drag it into place. Depending on how many columns you have selected from the Column Group Count you will only be able to drag and drop the selected amount.
To remove a column drag it from its position into the table where you would like it to be placed.
NOTE: If you change the number of Columns you do not need to resubmit the form. It will automatically update
NOTE: It is not possible to group fields that use variable digital denominations for example Sales, Cost or Tax. You will be given the below notification if a field is not suitable.
Example of 1 Column Group Count.
The Data Performance Table will now show differently, it is now in the group view.
Now grouped by Shops you can use the arrow next to the shops name to drop down more information.
If you choose more than one grouping you will then have a stack of groups.
As shown below you will for example have Shops as the top filter then within shops you will have Date.
To change the hierarchy of the data the required column should be first. The data will always stack in the order you arrange the groups above.