It will be more helpful If you share some sample data or workbook in .twbx format.
However you can go through below links.
Feel free to ask f you've any query.
I've tried to create a viz based on your requirement. Just have a look and confirm is that what you wanted?
Workbook (9.2) attached for your reference. Feel free to ask If you've any query.
Champion Product.twbx 241.9 KB
I've gone through the links given. let me give you a small screenshot of how the data should look
for the above screenshot we have to make a dashboard where there is a pie chart showing sales data and if you see the next part it actually calculates the total based on sales and shows the store with maximum turnover, store with maximum quantity sold etc.
I hope this information is helpful. I need data in the format of champion store in the worksheet