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

Multi-level grid

1 Answer 79 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Paul
Top achievements
Rank 1
Paul asked on 26 Jun 2017, 02:11 AM

Hello,

   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?

1 Answer, 1 is accepted

Sort by
0
Stefan
Telerik team
answered on 27 Jun 2017, 07:14 AM
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:

http://demos.telerik.com/aspnet-mvc/grid/hierarchy

http://demos.telerik.com/aspnet-mvc/grid/detailtemplate

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:

https://www.progress.com/services/outsourcing/feature-customization

Regards,
Stefan
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.
Tags
Grid
Asked by
Paul
Top achievements
Rank 1
Answers by
Stefan
Telerik team
Share this question
or