Working with GroupBy in SharePoint Charts


Step 1:  Open SharePoint Chart Designer




Step 1: Select a SharePoint List as DataSource





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.





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.




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