To measure the cycle time between similar transactions

[eramzan]

Hi,

I need a measure that allows me to measure the cycle time between similar transactions.
I have a data table with a list of transactions that I would like to be able to calculate the time from the last transaction of the same type. The columns of data would include transaction types, product information, project names, and transaction date. I want to be able to pivot on the project name, time frame, and the transaction type and find the average cycle time between transactions.
Please Help.

Regards:
Muhammad Ehsan

 

[powerpivotpro]

Would love to help with this problem, but can you give us a little more detail of what your data looks like?