Pivot Field Dialog
Use this dialog to add subtotals to a Row Label when exporting table data to an XLSX file with pivot tables.
Options
Field |
Description |
Custom Name |
Assigns any name you wish to the column name. This name displays in the Pivot Table Field List when the pivot table has been generated. |
SUBTOTALS |
|
Auto |
Adds a subtotal using the default summary function |
None |
Instructs Monarch Classic to not add subtotals to the pivot table |
Custom |
Instructs Monarch Classic to use a subtotal function different from that applied automatically or add other types of subtotals
|
LAYOUT & PRINT |
|
Show outline labels in outline form |
Displays the data in an outline (hierarchical) across columns. You can further:
|
Show outline labels in tabular form |
Displays the data in a table format. This setting allows easy copying from one worksheet to another. |
Insert blank line after each label |
Adds a blank line to the sheet after each label. |
Insert page break after each item |
Prints each pivot item on a new page. |
© 2024 Altair Engineering Inc. All Rights Reserved.