Comparing dates on Pivot tables?

[vikadle1]

Hi All,
I have 2 columns on a pivottable that I want to compare. closed date and due date
I want to check if closed date is greater than due date.

Any ideas, on how to achieve this on a pivot table.

 

[General Ledger]

Create a Calculated Field.

Go to the PivotTable-Analyze Ribbon > Calculations Group > Fields Icon. Select Calculated Field from the list of options.

Insert a Calculated Field such as =IF(Closed Date > Due Date, "Yes", "No")