Hello,
I haven't seen this in the demos or documentation (yet?). is it possible to display bars, lines or sparklines in the cells of a pivot grid ? is this supported by a public method or property? can this be programmed? is this difficult or extensive?
thanks in advance
Rolf Kaleveld
1 Answer, 1 is accepted
Hello, Rolf,
RadPivotGrid offers integration with RadChartView. Additional information on this topic is available in the following article:
https://docs.telerik.com/devtools/winforms/controls/pivotgrid/binding-with-radchartview
You can also refer to our Demo application >> PivotGrid >> Binding with RadChartView example which is quite useful on this topic.
I hope this information helps. If you need any further assistance please don't hesitate to contact me.
Regards,
Dess | Tech Support Engineer, Principal
Progress Telerik
Coming to you live from Progress360 in-person or on your own time, DevReach for all. Register Today.
Rank 1
Hello, Dess,
thank you for your answer.
we are not looking for a chart next to the pivot grid, but for a bar within a cell of the privot grid. the bar could represent the procential part of the cell value in comparison to the grand total of the column. the demo doesn't show this or does it?
Regards,
Rolf
Hi, Rolf,
The previously referred demo doesn't show charts inside each separate pivot cell. It demonstrates an integration between the selected data in RadPivotGrid and RadChartView.
Note that RadPivotGrid offers the CellCreating event which allows you to replace the default PivotCellElement with your custom one. In the PivotCellElement derivative you can override the CreateChildElements method where you can add whatever RadElement you need. Then, override the SynchronizeProperties method in order to adjust the custom element with the currently associated data.
However, such an approach is not recommended as it may affect the pivot's performance and smooth scrolling due to the big number of visual cell elements in the pivot. That is why I suggested the chart integration.