Pivoting Data - CSOIreland/PxStat GitHub Wiki

Home / End User Guide / Data/ Pivoting Data

How to examine downloaded pivot data:

1. Select the data range and classifications you wish to view from the Table tab on the Matrix page.

2. Click on the Pivot Button at the bottom of the Table tab on the Matrix page.

2. Choose the pivot option you want to use.

3. Once the pivot is chosen click Download and choose the XLSX option from the menu.

4. Open the XLSX with any spreadsheet application. If using Microsoft Excel click on "Enable Editing".

5. Click on the "Pivoted" sheet.

6. By default the pivot you chose will be displayed, however you can Drag & Drop the dimensions using the "PivotTable Fields" panel to alter the pivot of the data.