Use regular Excel pivot table tricks to create a report showing the top 5 stores for selected divisions.
This video is designed to accompany the book, PowerPivot for the Data Analyst: Microsoft Excel 2010
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
MrExcel Excel Videos
Learn Excel from MrExcel - Excel tips and tricks from Bill Jelen.
I hate the compact view for pivot tables. The PowerPivot team gives us Flattened pivot tables.
This video is designed to accompany the book, PowerPivot for the Data Analyst: Microsoft Excel 2010
See how to calculate columns in the PowerPivot grid using DAX.
This video is designed to accompany the book, PowerPivot for the Data Analyst: Microsoft Excel 2010
This episode shows you how to manually define a relationship between two tables in PowerPivot.
This video is designed to accompany the book, PowerPivot for the Data Analyst: Microsoft Excel 2010
If you have data in Excel and want to get that data into PowerPivot, you could copy and paste, or you can use the method in this video; declare the data as a table, then create a Linked Table.
This video is designed to accompany the book, PowerPivot for the Data Analyst: Microsoft Excel 2010
Chapter 3 of the book is full of rants telling you why you wouldn't run every future data set through PowerPivot. PowerPivot's inability to automatically sort by custom lists is my number one complaint.
PowerPivot will not automatically sort your months into custom list sequence, which means that you will get month names arranged in alphabetical sequence of April, August, and so on. This video shows the eight-click workaround.
In Chapter 2 of PowerPivot for the Excel Data Analyst, you will see how to import a 1.8 million row text file into the PowerPivot window.
This video is designed to accompany the book, PowerPivot for the Data Analyst: Microsoft Excel 2010
Learn about the five benefits of PowerPivot in this introductory video from MrExcel.
This video is designed to accompany the book, PowerPivot for the Data Analyst: Microsoft Excel 2010
Eric writes in with a frustrating question; "Why can't the macro recorder record the action of creating a pivot table? No matter what I do, it hardcodes that the original pivot data is 469 rows tall." Eric doesn't want to learn VBA, but needs enough to be able to generalize the recorded code. Episode 1211 shows you a solution.
