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?