Hiya,
I am trying to find the best ways to demonstrate the most efficient means of displaying sales data in various ways including the best type of graphs.
I could do it using pivot tables and graphs but was wondering if this is the best way or can anyone demonstrate a better way?
I have attached a redacted file with some questions for reference.
1. Which Account has the most overall wins and what is the % share of total wins?
2. Which Account has the most open sales and what is the % share of total open?
3. Name the accounts that are 10th to 20th on total wins and total open
4. Which products have the most wins and which have the lowest?
5. Where would you focus a sales campaign outside product C?
Thanks
Bookmarks