Designer “Rows / Columns”

This designer shows what is displayed on the rows and columns. It is located in the upper part of the window above the table:

On our example we see that columns display time, and rows display products. Let’s show how this can be changed.

Drag the item “Date.Calendar” on rows:

During the movement process you can notice a vertical red line shown in the place where the item will be dropped. The result after the movement will be the following:

Drag the element “Product” on columns in the same way. After these operations the page will look like this:

You can drag and drop “Dimensions” and “Measures” (in the left part) on rows and columns:

Let’s drag the item “Reseller Type” on columns and drop it after “Product Categories”. We will get the following page:

The sets of “Reseller Type” and “Product Categories” are “crossjoined” and thus the page allows us to see which product was sold by which reseller.

In the same way you can combine arbitrary number of dimensions and measures on the rows or columns, getting arbitrary pivot table.