Pivoting Report Data

In the Table Configuration tab, you can select Pivot Table to pivot the data displayed in your table columns. Pivoting organizes the data displayed for a selected dimension according to your reporting requirements. The ordering of columns in a report or statement means that the column with the dimension you want to pivot must be placed at the end of your list of configured columns. In your report or statement, this pivoted data is displayed on the right side of the table. You can only pivot by one dimension at a time in your report or statement.

Note:

Pivoting applied to your lenses in Analytics Studio is not applied to the data displayed in your report columns. You can only pivot the data in your report by selecting Pivot Table in the Table Configuration tab.

Pivoting Time Period Type Lenses

If you apply pivoting to more than one time period type lens, where these lenses have different periods with null values, then the columns displayed in your report will not be presented in chronological order. To resolve this issue, see Pivoting Time Period Type Lenses.

Note:

If you select Soft Dates, pivoting is automatically applied to the soft date columns displayed in your report.