Working with GroupBy in SharePoint Charts

 

Step 1:  Open SharePoint Chart Designer

 

 

 

Step 1: Select a SharePoint List as DataSource

 

GroupBy1.jpg

 

 

Step 2: In the image below more than one entry appears for same month. Same labels can be grouped and aggregate functions can be applied in each group.

 

GroupBy2.jpg

 

 

Step 3: Go to Group Data & Drilldown Tab and select required fields to apply GroupBy. Then you can set aggregate functions that can be can be applied on a field for each group.

GroupBy3.jpg

 

 

Step 4: Go to Customize DataSeries and select TotalRevenue as YValue of the DataSeries. Then Click 'Ok' button to finish the design.

 

 

GroupBy4.jpg