How to: Pivot data

Goal

How to summarize data by pivoting on one or more dimensions.

Solution

1. Add a Data Source to the Project. How to add a Data Source.
2. Click on the "+" next to a dataset to open the available action list.
3. Choose Pivot.
   
4. Click on the "+" next to 'Rows', select the columns to your row dimension and confirm with the Apply button.
5. Click on the "+" next to 'Columns', select the columns to your column dimension and confirm with the Apply button. Note that only columns with a cardinality under 100 are selectable.
6. Click on the edit icon to set the values.
7. Mark the required values and confirm with "OK".
8. Select the measures or at least mark the checkbox "Include row count". Pivoting proceeds. The pivot table is displayed on the left.
9. Press the Apply button at the top right corner to create the new View with the Pivot results.