# Pivot data (Writeback Matrix) 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.

You can manage your pivots using variables. Pivot and Variables are linked by using the toggle button while defining the variables.

Enable the Region of Sales variable to Pivot by Region.

Disable the Region of Sales variable to Pivot by City.

--- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.inforiver.com/working-with-inforiver/4.-adding-business-logic-and-formulae/pivot-data-writeback-matrix.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.