| Create a #PowerPivot report filtered by the Top X Users by "Logic" |
| Written by Denny Lee |
| Thursday, 28 January 2010 00:36 |
|
I was recently working with a customer to help them solve an interesting PowerPivot problem where they had wanted to get the Top 10 users within their data set and create reports based on that. One approach is to create a rank function within PowerPivot as noted in a Rank function thread on the SQL Server 2008 R2 PowerPivot for Excel forum? Another way is to create a Pivot Table where the UserID was placed in the [rows] and the measure in question in the [data] area; and sort the data from largest to smallest. Read more - Part 1...Read more - Part 2... Read more - Part 3...
|
Author articles
- Can I access PowerPivot via a data access API?
- Help, my PowerPivot for SharePoint Lists Atom Feed has fallen and it can’t get up!
- PowerPivot Technical Diagram: PowerPivot Security Architecture
- PowerPivot, you are so insensitive! (case that is)
- "DAX Reference" - free online chapter from the book "Professional Microsoft PowerPivot for Excel and SharePoint"
Most Popular
- Step by step guide on installing PowerPivot for SharePoint on a single machine
- List of suggested datasets to test PowerPivot
- List of PowerPivot DAX functions with description
- How to install PowerPivot for Excel and list of know issues
- Microsoft Virtual Lab: PowerPivot for Excel 2010 Introduction
- List of PowerPivot DAX functions (short)
- Learning PowerPivot and DAX
- PowerPivot's impact on BI pros?



