Pivot - Intergraph Smart Materials - 10.2 - Help - Hexagon

Intergraph Smart Materials Web Help (10.2)

Language
English
Product
Intergraph Smart Materials
Subproduct
Web
Search by Category
Help
Smart Materials/Smart Reference Data Version
10.2

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.

    BIRPivot

  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.

    BIREditPivot

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.

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