Hi, excel have a very nice feature that, when on a pivot, if you double click a cell, it shows the full dataset which is bound to the same cell.
It is possible to achieve the same by using the radpivotgrid?
For example we need to know, when a user double clicks on a cell which is the result of an aggregate (sum, average etc..) what are the rows on the dataset which generated that sum.
Best
Andrea
2 Answers, 1 is accepted
Hello, Andrea,
RadPivotGrid provides tooltips with information about the hovered cell's value out of the box:
You can handle the cell's clicking and get the aggregated value. The following forum post is quite useful on this topic: https://www.telerik.com/forums/how-can-i-get-selected-cell-value#2qeXovBdSkme0nFBxKoCLw
However, I suppose that you need something similar to the drill down functionality that RadPivotGrid offers: https://docs.telerik.com/devtools/winforms/controls/pivotgrid/drilldown
Thus, utilizing the GetUnderlyingData method you can extract the records from the data source object responsible for accumulating the result for a particular row and column. The GetUnderlyingData method is working with two parameters: Row Group and Column Group. Then, you can display the relevant data in a RadGridView. Please refer to the above referred help article 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, Sr.
Progress Telerik
Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.
Rank 1
Thank you, that's exactly what I needed.
Andrea