How to sort the pivot item with DateTime format

In our pivot grid, you can able to sort the column based on the dates by setting Comparer for the specific Pivot Item. This can be achieved by writing Comparer for the Pivot Item which has “DateTime” field as FieldMappingName, so that it gets sorted based on the chronological order.

C#

Figure: Pivot column with DateTime format appears in chronological order