the solution to your problem will depend on the structure of your data and how complete the data set is (i.e. are the data sparse ) please attach a twbx workbook with the data (at least some representative)
thanks for the reply.
Lets consider Sample super store data attached.
I am able to find how many customers are purchased in year. As you see below there are 637 customer purchased in year 2013 and 693 were purchased in year 2014.
Now my requirement is to find how many are purchased in 2013 (selected year) were also purchased in other years and their count. i.e. out of 637 in year 2013, how many were purchased on year 2012, 2011 and 2014?
similary if i select year 2014 (see pic 2),out of 693 in year 2014, how many were purchased on year 2012, 2011 and 2013?
Sample - Superstore.xls 3.2 MB