Working with data display formats of DataField in Pivot Table

“Rank Smallest to Largest” and “Rank Largest to Smallest” display format option

ASpose.Cells provides the ability to set the display format option for pivot fields. For this, the API provides the PivotField.DataDisplayFormat property. To rank largest to smallest, you may set the PivotField.DataDisplayFormat property to PivotFieldDataDisplayFormat.RankLargestToSmallest. The following code snippet demonstrates setting the display format options.

Sample source and output files can be downloaded from here for testing the sample code:

Source Excel File

Output Excel File

Custom sorting in Pivot Table Get External Connection Data Source of Pivot Table