I am building a Market Model looking at our Market Share versus competitors by Hospital and Surgeon.
My first attempt has not worked and only showed the totals for the first company selected
I am collecting in a Excel file with the columns:
State, Sales Rep, Hospital, Surgeon, monthly usage, Our usage, One column for each competitor usage
NOTE: Surgeons will work across several Hospitals
What I can’t work out is if I bring this into the Query Editor, how can I make sure that each column sums up independantly so I can see Share by Sales Rep, Share by hospital, Share by Surgeon. I also want to rank each company based on usage. My Excel columns are attached.
Do I need to change the data collection excel file or do I just need to do something different in the QUery editor?