market share calculation issues

Hi all,

here's the raw file format for the data (Excel):

Please note that:

- the section with date is in text format (for PBIX file), and it cannot be converted it to data format as weel - already tried, PBIX cannot perform the operation;

- both  brand and license data are reported as text, while the only number format is for Sales data.

- I remind you that I cannot modify the format in any case.

The desired result is to display a pie chart which shows how much the 'Not Specified' total sales for weight (in terms of percentage) compared to the total amount of the ficitional Licensed goods for 2018 --> in other terms, I have to display graphically the market share of both Licensed and non-licensed goods.

Hope this would help you to figure out your solutions to my problem!

Thank you.