Pivot - Intergraph Smart Materials - Version 2016 R4 (8.4.0) - Help - Hexagon PPM

Intergraph Smart Materials Classic Help (2016 R4)

PPMProduct
Intergraph Smart Materials
PPMCategory_custom
Help
Version_SPMat_custom
2016 R4 (8.4)

A pivot report transposes rows into columns to generate results in a crosstab format. You select pivot columns and rows and then provide the functions to be represented in the pivot report. Once created, pivot reports display a new icon in the search bar.

Create pivot reports

  1. Select Actions > Format > Pivot to open the Pivot dialog.

  2. Select the columns to display in Pivot Columns. To add additional columns, click Add Pivot Column.

  3. Select the rows to display in Row Columns. To add additional columns, click Add Row Column.

  4. For computation, select a function and a column, define a label and a format mask. To create a sum, select the Sum check box (optional). To add additional functions, click Add Function.

    If you do not enter a label, the report displays the internal item name.

  5. Click Apply.

  6. You can use the buttons next to the Actions box to toggle between the pivot and the report view.

Edit pivot reports

  1. Click Edit Pivot.

    The Pivot dialog appears.

  2. Edit the attributes.

  3. To remove a previously defined column or row, select the default setting, Select Pivot Column and Select Row Column.

  4. Click Apply.

Delete pivot reports

  1. Click Edit Pivot.

    The Pivot dialog appears.

  2. Click Delete.

You can also click the Remove Pivot icon to the right of Edit Pivot.