Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Reporting Services CHART - TOP 10....?

Posted on 2008-06-13
2
Medium Priority
?
1,477 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 2000 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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how the fundamental information of how to create a table.

876 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