SSRS: Diagram: Cumulate Values into new field

• gb 86916

  Mr or Mrs. 500

  Points: 562

  More actions

  September 19, 2013 at 3:01 am

  #279886

  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.

  

• Mark Fitzgerald-331224

  SSCrazy Eights

  Points: 8489

  More actions

  September 19, 2013 at 4:00 am

  #1651422

  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

• gb 86916

  Mr or Mrs. 500

  Points: 562

  More actions

  September 19, 2013 at 5:18 am

  #1651445

  Thanks a lot 🙂