Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Creating an "other" group Expand / Collapse
Posted Friday, December 20, 2013 11:14 AM


Group: General Forum Members
Last Login: Friday, August 14, 2015 9:44 AM
Points: 15, Visits: 66
Hi everyone

One of the tasks that I have not been getting close to solving is showing an
"other" group in my bar charts.

Once again, I am looking at a sales report and I have a small number of large customers and many small customers. I have created a report which shows the top X customers as ranked by sales or whatever but in the case of top 10 customers I would like to have an eleventh category named "other" which shows the sales of all the non-top 10 companies.

Crystal seems to do this quite well, SSRS and Pie Charts maybe... kinda does it if you can define a fixed cutoff but I just don't see an easy way to do anything with bar charts.

Has anyone run across a solution?

Thank you and Merry Christmas!

Tom D
Post #1525118
Posted Friday, December 20, 2013 12:52 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, July 8, 2015 2:21 AM
Points: 46, Visits: 216
It'easy with a Pie Chart.
With a Bar Chart you have to rearrange your Dataset and aggregate your small data in a single slice.
Post #1525157
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse