The OrderingType class contains the options for ordering a PivotTableField |
public sealed class OrderingType |
Public NotInheritable Class OrderingType |
CalculatedFields will return OrderingType.Normal. You can check if a PivotField is calculated field with the IsCacluatedField Property |
Name |
Description |
---|---|
Manual |
This is the default Ordering in Excel. When the file is opened in Excel items can be rearranged by dragging them |
Ascending |
Items will be arranged in ascending order (A-Z) |
Descending |
Items will be arranged in descending order (Z-A) |