This is a migrated thread and some comments may be shown as answers.

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

2 Answers 6 Views
PivotGrid and PivotFieldList
This is a migrated thread and some comments may be shown as answers.
Andrea
Top achievements
Rank 1
Andrea asked on 04 Nov 2020, 09:26 AM

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

Sort by
0
Accepted
Dess | Tech Support Engineer, Principal
Telerik team
answered on 05 Nov 2020, 09:43 AM

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/.

0
Andrea
Top achievements
Rank 1
answered on 06 Nov 2020, 12:14 PM

Thank you, that's exactly what I needed.

 

Andrea

Tags
PivotGrid and PivotFieldList
Asked by
Andrea
Top achievements
Rank 1
Answers by
Dess | Tech Support Engineer, Principal
Telerik team
Andrea
Top achievements
Rank 1
Share this question
or