Pivot data

Business reporting and analysis often involve pivoting data and interchanging the order of row dimensions. You can re-order dimension parameters from Power BI, however, you would end up losing data input fields.

The new Pivot option allows you to create aggregated tables or views within the Inforiver visual, with different combinations of row dimensions. The Pivot Explorer, when enabled, retains all your pivot views so you can easily switch between them for analysis.

Creating pivot views in Inforiver is a simple, straightforward process outlined below:

STEP 1: Enter a relevant name for the pivot view.

Pivot view name

STEP 2: Add row dimensions by selecting the checkboxes. Click Save.

Add row dimensions to pivot view

STEP 3: Click the Add link to create new views.

Add new pivot view

Pivot views for different row dimensions

Within each pivot view, you can create data inputs, forecasts, formulas, snapshots, and scenarios corresponding to each combination of dimensions. The pivot view/table you create also lets you enter numbers at the higher level and allocate proportionally to all the relevant sub-levels.

Notice how the single select (ProjectStatus) and formula (NormalizedSales) values change based on the pivot selection.

Switching between pivot views