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

SSRS: Diagram: Cumulate Values into new field Expand / Collapse
Author
Message
Posted Thursday, September 19, 2013 3:01 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, September 30, 2013 1:33 AM
Points: 10, Visits: 15
Hi there I'm currently using this Diagramm to Show percentages of Invoice Amount by Customers for my Company. (Picture below filters out Values that are under 4%)

now since i have a lot of Customers that take less than 4%, i was hoping it could be possible to cumulate them all into a Collective Company called "Others" I'm Using SQL Server Reporting Services 2012.

Does anybody know how this is done ? Many thanks to you all.
Post #1496272
Posted Thursday, September 19, 2013 4:00 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 2:34 AM
Points: 3,107, Visits: 1,347
Using the chart you have at present (with the filter / dataset parameter removed).

Set the following SSRS expressions : (guessing the column names but you will get the gist)
Group on and label for the category groups :

=iif(Fields!ValueToShow.Value<4, "Accumulated smaller segments", Fields!NormalGroupingName.Value)

Fitz


  Post Attachments 
pies.jpg (5 views, 60.71 KB)
Post #1496285
Posted Thursday, September 19, 2013 5:18 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, September 30, 2013 1:33 AM
Points: 10, Visits: 15
Thanks a lot :)
Post #1496315
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse