When you create an advanced report in Excel, you might have different options or combination of tools.
In this tutorial, I create an advanced Excel report using Pivot tables along with Dynamic Array Functions. Then I create the same report using a little trick in Power Query.
Let me know in a comment which method you prefer.
Now, let’s have a look.
To book a Corporate Training anywhere in the World check
www.OfficeInstructor.com
Here is a contribution from a Friend to the Channel (Thank you Ivan Cortinas):
We add the table to the data model. We create 2 measures.
If the name of your table is Group3...
TotalSales:=SUM(Group3[Sales])
SalesCustomerList:=CONCATENATEX(VALUES(Group3[Customer]),Group3[Customer],", ")
Then you create Pivot Table from Data Model and move Region and Manager to Rows and move the measures TotalSales and SalesCustomerList to values.
Негізгі бет Power Query Hack vs Pivot Table with Dynamic Arrays - Excel Report
Пікірлер: 37