Skip to main content

Displaying Properties in a Pivot Table

Displaying Properties in a Pivot Table

You can display the properties of a level if you are also using that level as rows or columns. For example, if you display City as rows, you can display Principal Export as a column by dragging the property to the Columns box:

Cities as rows, with principal export shown for each; values: iron, video games, and so on

If you display City as columns, you can display Principal Export as a row:

Cities as columns, with principal export shown for each

Displaying Both Properties and Measures

If you display a property as a column and you want to display a measure as another column, you must drag and drop the measure to Columns rather than to Measures. For example:

Transposing a Pivot TableNext section
Previous sectionDisplaying Measures in a Pivot Table
Purpose of this instance: Draft documentation
DocReleaseID: IRIS2025.1
Content loaded from:
/staging/learning/iris-doc/2025.1.x/doc/cache/en-us/src/
/staging/learning/iris-doc/2025.1.x/doc/ensemble/en-us/src/
/staging/learning/iris-doc/2025.1.x/doc/security/en-us/src/
/staging/learning/iris-doc/2025.1.x/doc/iris/en-us/src/
Excluded items: EAST, EDICOM, EHL72, EHL7T, HXHCINST, HXHCRN, HXIHINST, HXIHRN, PAGE_healthcare
FeedbackOpens in a new tab