Adding dimensions
Last updated
Last updated
When you drag and drop a Qommentary Pivot Table extension to your sheet, you will be prompted to select Dimensions.
Adding dimensions works in the same fashion as like Qlik Sense charts. To add a dimension to your table, click on Add dimension and select a dimension from the list.
Add as many dimensions you need to see in the table and expand dimension to view the properties, When you use more than one dimension, they are automatically nested together and displays in the same order as defined for left and top views. If table has 2 dimensions selected, expanding the first dimension displays its next dimension values.
The Qommentary Pivot Table extension allows dimensions to be displayed as rows or columns, thus enabling data to be sliced and diced in different ways.
To change the dimensions position, follow these steps:
1. Edit your sheet
2. Click on the Qommentary Pivot Table extension
3. Expand dimension properties
5. Select Left to display dimension data as rows
6. Select Top to display dimension data as columns
During table analysis, users can pivot dimensions between rows and columns by the use of drag and drop actions.
Totals can be enabled to aggregate measure values on rows and columns.
To enable Totals for dimensions, follow these steps:
1. Click on Edit sheet button
2. Expand the dimension properties
3. Scroll down to the Show totals property and turn on the switch
You will now see Totals for the selected dimension
The Totals label can be easily customized to add further context to your data. Expressions are allowed.
To customize Totals label, follow these steps:
1. Click on Edit sheet button
2. Expand the dimension properties
3. Scroll down to the Totals label property and enter desired text
The selected dimension will now display a customized Totals label:
4. Scroll down to the Position property
