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?I figure out how to accomplish this. If anyone needs help doing this,
ping me.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment