Add calculation to date field in PivotTable

Hi there,

I have a pivot table with a field called "created on" which is a series of dates, i want to create a field called "Days in Pipeline" which would essentially be =TODAY()-'Created On'

This doesn't seem to work, i get an error: Your formula includes a function that cannot be used in PivotTable formulas....

Any suggestions?

Hi,

Can you not insert that (TODAY()-'Created On') as a separate column in the raw data and show on the Pivot Table?