Use Today Date Calculation in Pivot Table

[yarivsa]

Hi,

I need help to Calculate Date in Pivot Table,

I have date with Order number and Delivery date of the order,
I want To Calculate if the order delivery is Late or on Time.

The Calculation i want to use in Pivot Table is:

Promised receipt date - Today Day= Numbers of Days

I try to use Calculate Fileds with Today() function but didn't success

If anyone have an idea how to solve it let me know

Thanks

Attched Example of my Data

[NBVC]

You can't include the TODAY() function or cell references in the Calculate Fields options...

You could either do the calculations outside the pivot table itself, or add a column in the data and then drag that to the Pivot table too.

[yarivsa]

Thanks for your replay i will try to do it