Hi @soham,
There is quite a lot to digest with this scenario and is a bit hard to tell all of the functionality and the setup of the data through screenshots. This scenario may be easier to assist with if you were able to upload an anonymized copy of your analysis to the Arena View.
In terms of the multiple rows being created where you only want one, what is the metric that is different (so the one causing the multiple lines), are the SKU’s different? What are the 6 entries (3 per retailer) that are showing?
If you said it’s working properly when only one product type is selected, that leads me to believe that the separate rows are accounting for the various product types selected?
If that’s the case, have you tried building a calculated field that sums the product types instead of leaving as separate rows?