Adding dimensions

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.

Dimension position

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.

Enabling totals

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

Customizing totals label

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:

Last updated