Requirement: two countries will be accepted as input parameter(one base country other for compare), we need to find the sales difference between these two countries for different products. Then we need to to create the distribution pie chart for the difference of sales like below,
In above chart, from row number 2 we can conclude that there are 4 product which has sales difference between 0 to 10.(if any country dont have same product for comparison then it sales will be considered as zero)
Tableau screenshot to understand the data.
Attachment: twbx and sample excel
Thanks for your intentions to solve this problem.