all groups > sql server reporting services > may 2006 >
You're in the

sql server reporting services

group:

Display top N records and its total


Display top N records and its total Nergock NO[at]SPAM gmail.com
5/22/2006 7:02:36 PM
sql server reporting services: For a given dataset, I know how to display the top-N records. Is there
a way in reporting services to then show the total of those top-N
records?

For example, let's suppose I have a dataset of sales people and their
sales totals. By grouping on the sales person, I am able to display
the top 5 sales person base on their sales total. I then need to
display which % of total sales these top 5 sales person represent.
Some like this:

Top 5 sales
Bill 35%
Lucy 10%
Bob 7%
Jeff 5%
Kim 3%
Total: 60%

Is this possible?
Re: Display top N records and its total Nergock NO[at]SPAM gmail.com
5/22/2006 7:32:26 PM
I figure out how to accomplish this. If anyone needs help doing this,
ping me.
AddThis Social Bookmark Button