Problem with Pie Chart using Telerik report Designer

[Joan]

Hi i'm trying to generate the pie Chart attached in the file ...

I have a SQL source with this 3 columns:

Category  ---- Sector .....  Numofitems

C1                     A                 125

C1                     B                 175

C2                     F                 200

C1                     N                 135

I need a pie than first made the groupby Category -- num of ítems and their % so in the legend only have 2 categories in this case.

and the in this category made the groupby Sector -- num of ítems and their %

 

But I can not know how first group by Category and then by sector with the telerik report Designer ...

I hope looking the file attached you will see what i need ...

 

Thanks,

 

Joan

 

[Stef]

Hi Joan,

You can create a Pie Chart by using the Graph item, where series can be grouped by Sector and Category both and the values will be NumOfItems.

There will be generated a piece per Sector/Category value, where you can apply conditional formatting (DataPointConditionalFormatting) on the BarSeries to color pieces based on the Category.

The legend can be formatted through the series LegendItem properties e.g. use ConditionalFormatting to hide unnecessary entries, the Value property to create proper expression calculating aggregates based on the corresponding series groups and whole graph's data, and MarkConditionalFormatting to color the markers as the data points (bar series)..
Note that expressions are hardcoded, but you can use even custom functions to create valid conditions for applying the proper style on series and legend.

The attached report illustrates the above suggestions. It can be previewed with the Standalone Designer tool of Telerik Reporting Q3 2015 v9.2.15.930.


I hope this information is helpful.

Regards,
Stef
Telerik