Top N, Bottom N Grouping in SSRS 2008

Who is online?  0 guests and 0 members
Home  »  Blogs  »  MikeDavis  »  Top N, Bottom N Grouping in SSRS 2008
abhi_MSBI likes this.
 
0
/5
Avg: 0/5: (0 votes)

Comments (9)

schilders
schilders said:

Hi Mike,

Your SSRS 2008 webinar was great this morning!  I am trying to do something similar to your blog post in SSRS 2005.  The main difference is that I don't need to show the contents of the Others catch all category.  I'm using patient city and encounter count from my SSAS cube and have created a report with a table object.  I simply want to show the top 20 zip codes / cities with encounter count for each, along with an Others catch all category and a grand total.  Can you step through how this is accomplished in SSRS 2005 using a SSAS cube as my data source?

Thanks,

Sid

8/19/2010
 · 
 
by
mikedavis
mikedavis said:

Schilders,

I am not sure what else you need except for the instructions I gave in the blog. If you don't want to show the others group then don't create it. Other than that I am not sure what else you are asking.

8/19/2010
 · 
 
by
nitz
nitz said:

while the use of top N and bot N is appreciated, what is the value of this report? results appear as though they are just an alphabetical listing of products within a given category, showing M - Z as the top and A - L as the bottom. I'd expect any value to come from showing top 10 and others based on a given product sales amount. This report would start with Sport-100 Helmet Red - $78K and work it's way down. That would be more useful and more of a challenge.

2/3/2011
 · 
 
by
MikeDavis
MikeDavis said:

Nitz,

Yes top N by product name is not very useful. But I could have selected Top N by Sales Amount, or a measure that was important to my company.

2/4/2011
 · 
 · sridhar_babu83 likes this.
 
by
gaurishitre
gaurishitre said:

I want this same situation for Char

I want to Migrate Crystal to SSRS .

In crystal there is facility for top N and others , but in SSRS I dont find Others option..

 

2/21/2011
 · 
 
by
meganathank
meganathank said:

Hi Mike

What a innovative approach, Cool!

Cheers!

3/14/2011
 · 
 
by
drew9
drew9 said:

found this page through google.  just getting started with ssrs 2008.  tried to follow the pictures, but no luck.  do you have a more detailed step by step directions on how you designed the report above or maybe the same report to download.  thanks.

6/6/2011
 · 
 
by
MikeDavis
MikeDavis said:

Drew9,

I will work  on a more complete blog covering this topic. Several issues can cause this technique not to work. Sorting and duplicate items cause most of the issues.

6/6/2011
 · 
 
by
MikeDavis
MikeDavis said:

I wrote anther blog cover some of the issues with this method.

http://www.bidn.com/blogs/MikeDavis/ssis/1875/ssrs-top-n-and-bottom-n-reporting-with-duplicates

6/13/2011
 · 
 
by
Blogs RSS Feed

MikeDavis's latest blog posts

Blogs RSS Feed

Latest community blog posts