Sorting
The sorting section permits you to define the sort order for each dimension in the pivot table.
![]() |
Date formats
The extension only supports YYY, YYYY MMM, MMMM.
Data Handling
Data Handling section gives you control over when the Pivot Table is calculated and whether you wish to display or hide zero values.
![]() |
- Show Zero Values
Rows or Columns that are only 0's in the chart will be shown or suppressed.
- Calculation Condition
Only calculates the Object if this condition is true.
- Displayed Message
Determine the displayed message if the Calculation Condition is not true.