$\backslash$table$[[$Salesperson$,,$Location$],[$Smith$,1000,$Houston$],[$Paul$,1001,$Dallas$],[$Johnson$,1002,$NY$],[$Tran$,1003,$Houston$],[$Ngo$,1004,$NY$],[$Alvin$,1005,$LA$],[$Beach$,1006,$Dallas$],[$Fields$,1007,$Houston$],[$Thomas$,1008,$Dallas$],[$Vines$,1009,$NY$],[$Jones$,1010,$LA$]]$

Instructions

Create a dashboard that shows the following $($each in a new tab$)$

Sales by salesmen

Sales by Location

Make sure to use graphical tools in Excel to visualize numbers

Bring attention to top $5$ sales in the salesmen tab

Bring attention to the proportion of sales by Location