From the course: Excel Power User Challenge

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Unwind this report

Unwind this report - Microsoft Excel Tutorial

From the course: Excel Power User Challenge

Start my 1-month free trial Buy for my team

Unwind this report

“

- [Instructor] We want to get a summary of this data. And we want to do it all in Power Query. We've got the models, the prices, and all of these customers, and say, customer two ordered 60 of E-077 for 9.25 Euros. We want to take this into Power Query, unpivot it, get a total count for each item, we don't want to know about the customers one through 10. We don't need that. And multiply the price and total count for each item. You got that? Go ahead, work it out, get the totals, come back, and I will meet you in Power Query. Let's go. My cursor is inside the dataset. I'm going to right click, Get Data From Sheet. Yes, it does have headers, OK. Now here is one catch, we've got to highlight model, that's already highlighted. Now I'm going to hold down the CTRL key. Select the Price column, right click, Unpivot Other Columns. Boom. We don't need these customers. Right click that, Remove. Next, I want to Group By. Group…

Contents