It would be really useful to be able to have a separate filter for each section of a combined grid.
I have a grid where we want to see year 1 by month (Grid 1) and year 2 and 3 by year (Grid 2) and then a total for all three years. I can set up a set of time filters that gives me this result so no issue there. The challenge is that year 2 exists in both grid 1 and grid 2 - under the current filters it will appear twice.
I have a workaround using 3 grids;
- Grid 1 - time range year 1 in months no total
- Grid 2 - time range year 2 and 3 in years no total
- Grid 3 - no time - timesum on Grid 1 and Grid 2
The challenge is that I now have an additional admin burden to update multiple time ranges at year end. Additionally any data in the module will be lost when the time range is rolled forward, would have preferred to achieve the same effect using a filter (there will be a snapshot so we will only loose inflight data).
This is the workaround that I have;
Ultimately it would be good to be able to use a separate time filter for each section of the grid which would reduce the overall admin burden and simplify the set up.
