How to show the portion of dataset which generated values in a cell

[Andrea]

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

[Dess | Tech Support Engineer, Principal]

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

[Andrea]

Thank you, that's exactly what I needed.

 

Andrea