How to find % contribution of sales by people of particular year in successive year ?

[shekhar_analyti]

Hi All ,

I have three requirements .

1) How to find % contribution of sales by people of particular year in successive year ?

   I want to find % contribution  to sales in different years by customer who did purchase in 2014 ...

2) Retention percentage of customer of last year over successive year .. something like running retention percentage ?

   Example - All the customer of 2014 were retained in 2015 and Just two new customer joined , Cyrill and Nalani .

                   In 2016 only customer : Cyrill of 2015 was retained ...

3) Fresh Customer joined in different years

Thanks and Regards

Shekar

[sergio0592]

For this item  "I want to find % contribution  to sales in different years by customer who did purchase in 2014 ...", youb can make a pivot table with ID_CUSTOMER as row and Yera as column and use as expression :

=sum({$<CustomerID =P({<Year_of_Sales={"2014"}>}) >}  Sales)
/
sum({$<CustomerID =P({<Year_of_Sales={"2014"}>}) >}TOTAL <Year_of_Sales>  Sales)

[shekhar_analyti]

Hi Jean ,

Thanks for the reply .

[shekhar_analyti]

antoniotiman  help me on retention percentage of customers ..

[shekhar_analyti]

stalwar1‌ .. Please help

[shekhar_analyti]

!

Hi Jean ,

I wanted my data something like this