This article is part of the Demo report guide on getting started with Telerik Reporting and demonstrates how to add a new graph which will display the top five stores per year and per quarter.
Click on the Report Header section and then go to Insert > Bar > Clustered Bar to add the new graph next to the pie chart.
From Graph Wizard, use the graphDataSource, then drag StoreName to Categories, OrderDate to Series, and Sum(LineTotal) to Values.
Sort and filter the series groups and the category groups. You can also set specific colors through the Color palette option. Set the series groups in the folowing way:
Grouping : =Quarter(Fields.OrderDate)
Sorting : =Quarter(Fields.OrderDate) ASCSet the cetagories grpups in the following way:
Expression : =Sum(Fields.LineTotal)
Operator : Top N
Value : =5
Sorting : =Quarter(Fields.OrderDate) ASC
Preview the result by clicking Preview > PrintPreview.
You can find the full project in our GitHub repository.