Create a #PowerPivot report filtered by the Top X Users by (Part 1 of 3)

January 27, 2010 by dennyglee
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.
Advertisements

0 Responses to “Create a #PowerPivot report filtered by the Top X Users by (Part 1 of 3)”



  1. Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s




Denny Lee’s Tweets (1/2 of PowerPivot Twins!)

Copyright

Copyright © 2010 Denny G Lee - All Rights Reserved

%d bloggers like this: