From the course: Excel: Creating a Dashboard with Power Query (Microsoft 365)

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Linked table for sales by product category

Linked table for sales by product category

From the course: Excel: Creating a Dashboard with Power Query (Microsoft 365)

Start my 1-month free trial

Linked table for sales by product category

“

- [Instructor] Now we're ready to set up the third part of the dashboard, where we're going to create a table this time that captures the sales value by product category. And we want to do this for the latest and compare it to the previous month. Let's set up the calculations that we need for this. But before I start to add more pivot tables to this, let's just organize this part a little bit better, give each section a title. So I'll call this top sales managers. I'm also going to format it slightly, just so that I know this area belongs together. Give this one a name as well, and format this too. Okay, so so far we've set up our different pivot tables. Whenever we press refresh, our pivot tables will go and fetch the data from the external files. Now, currently we still have April as our last month, but once we're done setting up our dashboard here, we're going to upload May data and check if everything updates…

Contents