Trying to ID # of days span in a pivot table

[Steve Marchesi]

Hi,

I'm trying to use two specific completion dates attached to the same row of data in a table and use that data to identify average # of days- Example: Date Quote Completed & Date Quote Sent to customer- would like to track #of days between those two events related to specific row of data and determine the average for the entire data table. How would do this in a pivot table and how would I set this up?
Thanks,

Steve

 

[Luke M]

Setup a calculated field as:
=Quote_complete - Quote_Sent
Add that field to your PT, and change the Value setting to show average.