# Adding dimensions

When you drag and drop a *Qommentary Pivot Table* extension to your sheet, you will be prompted to select Dimensions.&#x20;

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.

![](/files/j63vhkJ1qtmBbA2KnP1S)

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.

![](/files/e0dtYGTDAbCez2dgm4H9)

### 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

4\. Scroll down to the **Position** property\ <img src="/files/S4VRxIZe7FQZbfWqhpYQ" alt="" data-size="original">

5\. Select **Left** to display dimension data as rows

![](/files/Ejscty6M8RiCm9YRXell)

6\. Select **Top** to display dimension data as columns

![](/files/Env4m74lF04BgjYlKWjf)

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:&#x20;

1\. Click on **Edit sheet** button

2\. Expand the dimension properties

3\. Scroll down to the **Show totals** property and turn on the switch

![](/files/73jWOW3FV2UOKD8l751D)

You will now see Totals for the selected dimension&#x20;

![](/files/N81kqrEQJbAJ9EbVTNL6)

### 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&#x20;

The selected dimension will now display a customized Totals label:

![](/files/EYPZrgi9RTGHMv5QuPke)


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://knowledgebase.qommentary.com/qommentary-pivot-table/setting-up-your-table/adding-dimensions.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
