Solved

Reporting Services CHART - TOP 10....?

Posted on 2008-06-13
2
1,439 Views
Last Modified: 2013-11-05
Experts:

I'm getting my feet wet with MS Reporting Services, using BIDS.

I have a very simple chart that lists count of customers by STATE.

Question: How do I tell the chart to ONLY show TOP 10 STATES based on customer count? As a secondary question, also how can I tell it to show TOP 10 STATES and also list a count for ALL OTHERS...?

THANKS
M
0
Comment
Question by:MIKE
2 Comments
 
LVL 30

Accepted Solution

by:
nmcdermaid earned 500 total points
ID: 21790777
I can't give you specific instructions but the general approach is to use some kind of rank function to rank them, then filter on that rank

0
 
LVL 17

Author Comment

by:MIKE
ID: 21794257
Oh ok... I thought the chart options could take care of this.

I'll see what I can do to rank them....
0

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Conditions in Where clause 9 46
Rebooting Witness SQL Server 2 23
How come this XML node is not read? 3 26
Connect Gridview column to Textbox in C# 2 35
Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
I have a large data set and a SSIS package. How can I load this file in multi threading?
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Viewers will learn how the fundamental information of how to create a table.

713 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question