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

3 posts, 1 answers
  1. Andrea
    Andrea avatar
    76 posts
    Member since:
    Oct 2012

    Posted 04 Nov 2020 Link to this post

    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. Answer
    Dess | Tech Support Engineer, Sr.
    Admin
    Dess | Tech Support Engineer, Sr.  avatar
    4172 posts

    Posted 05 Nov 2020 Link to this post

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

  3. Andrea
    Andrea avatar
    76 posts
    Member since:
    Oct 2012

    Posted 06 Nov 2020 in reply to Dess | Tech Support Engineer, Sr. Link to this post

    Thank you, that's exactly what I needed.

     

    Andrea

Back to Top