In part 1 we ended with:
Letís try to add the top2 product2 for each customer in the top 10. Start with adding the product column:
You will notice that the revenue for each customer has dropped. This means we first have to ďlockĒ the revenue on a customer / year level:
Okay that fixed, letís get the revenue by product:
Some how I donít think this correct. Letís get the details for one customer:
He has bought several products so letís tweak this some more. We need to add the TOPN2 Filter for product by customer by year.
Just add as an extra column.
Letís put it in a pivot to make it even more readable:
Till Next Time