Hi All,
We are trying to develop a report which are all the next interested items bought by the customers.
Scenario:
We have the invoice / Receipt table with items Qty & Price. Each invoice has multiple items with line Qty, Price & Total Receipt Value. First we need to know Top selling item in terms of value. After selecting the top selling the item, we need to know what are the next top items which are bought along with the item selected. And it needs to iterate for the different level.
Herewith I have sample attached file for your reference.
Regards
Rajesh