Multi-level grid

2 posts, 0 answers
  1. Paul
    Paul avatar
    1 posts
    Member since:
    May 2017

    Posted 25 Jun 2017 Link to this post


       My team is wanting to utilize a grid control to display data in a multi level format.  We looked into the pivot grid control, and that looks a little more complicated then what we need, and after looking over documentation, the Aggregate filter on the grid control looks like the closest match (Doc here).  What we are looking for is in the attached image, Grid Mockup.png.

    Essentially, the x-axis is the month/year for the data that we are looking for, with the current month needing to show up two times, once for the estimated month and the next column with month-to-date.  All the other columns are for a past month.  The y-axis is a given cost center.

    We want the top row(first level) to be an aggregate of all the data across all cost centers for the given time period, upon expanding the tree, it shows a second level where it is the overall cost center, then then it can be expanded further to show the third level where it is the specific cost center.

    I strongly feel the aggregate filter is what we are looking for, but is it possible to write our own filters?  Or is there a better way to do this?

  2. Stefan
    Stefan avatar
    3009 posts

    Posted 27 Jun 2017 Link to this post

    Hello Paul,

    Based on the Provided requirements, I can suggest checking the Hierarchical Grid, which can give the options to expand the column to show additional data. Please have in mind that the details records can be only rows as in the picture and not Grids as in the examples:

    Also, the total column can be set using the .ClientFooterTemplate() from the linked example with aggregates, but this will add it at the bottom of the Grid.

    If additional assistance is needed, with the custom implementation, I can recommend our Professional Services team:

    Progress Telerik
    Try our brand new, jQuery-free Angular 2 components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
Back to Top