For the above data I need to generate output this way.
Note:The numbers are arbitrary.This is only to show how the data looks and how the output must look.In real data, I have around 20 providers and 7 different drugs.
The percentage shows the percentage of the drug sales.
I tried this creating 20 different datasets for each drug and its sum and percentage.This is tedious in a way.
Any help is appreciated.