Search code examples
reporting-servicesreportreportingdiagramgeometry

SSRS: Diagram: Cumulate Values into new field

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.Diagramm

Solution

  • You can find good details on this at Collect Small Slices on a Pie Chart.

    Say we have a simple DataSet and a simple chart based on this:

    enter image description here

    enter image description here

    Now, in the Designer, go to the chart Chart Series -> CustomAttributes and update:

    • CollectedStyle
    • CollectedThreshold
    • CollectedLegendText

    enter image description here

    Now all your small slices are grouped together:

    enter image description here

    Obviously you may have to tweak slightly for your chart/data but this should give you a good start.