Calculate CLV

[#1]

Hello,

I have a pivot table which is showing how many purchases each user have made during the selected time space.(time space is displayed in years and months). I would like to add a column that would show the average time space that each user purchases.

Is there any way to calculate this ?

Thank you,

Meni