Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

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

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, June 4, 2014 1:20 PM
Points: 15, Visits: 63
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: Friday, July 25, 2014 1:36 AM
Points: 44, Visits: 207
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