Show on Excel dashboard sales by country and customer.
The Excel solution is quick and easy:
- Create a PivotTable From the sales database which shows sales by country.
- Set the TOP 10 filter on the data table. Derive the data from the PivotTable into a new table. Create a map from the "auxiliary" table.
- Create another PivotTable showing sales by customer and create a new sales graph from it
- Create a slicer and connect both Pivot Tables so that, depending on the selection in the filter, they show the same result, but divided by different attributes.
Watch the result in the video.
You can learn everything about automatic data connections, from databases to creating interactive reports, graphs, and maps in the Projects 3 › course.