Skip to content

Pivot statistics

Pivot statistics

Statistics are by default shown as separate columns:

Cube showing multiple statistics displayed as separate columns

The use of the Sigma symbol Σ as a statistical separator allows you to show statistics as a separate dimension which can be pivoted to arrange those statistics as columns in the cube or mixed in with other dimensions.

To see this information broken down by Gender:

Drag the Gender variable onto the Drop your variable here box next to the Sigma symbol Σ.

Cube showing Gender categories each subdivided by statistics columns

To change the display so that Gender categories are shown side by side each broken down by the People/Bookings statistics:

Drag the Sigma symbol Σ in front of the Gender heading.

Cube showing statistics columns each subdivided by Gender categories

To show both the People and Bookings statistics in the same cell:

Drag the Sigma symbol Σ from the horizontal dimension onto the vertical dimension.

Cube showing multiple statistics combined within the same cell