One way you can do this is by creating two parameters (so that 2 different products can be chosen) and then create a couple of calculated fields. I've reattached your sample workbook with instructions.
Hope this helps!
compare 2 products.twbx.zip 670.3 KB
Thanks a Lot.This really helped a lot.
However i have few more query not sure how to start on it.
1) need to see the pattern of the Products being purchased
Idea is to know which product is most purchsed by most of the customer at first and then the second product,third product..so on..(which products follows which product).
Once the pattern is developed,
2) need to know which customers are not following the general pattern of products purchased so that those customers can be targetted for future sales.