I am filtering my grid in 2 different ways.
I need the 1st filtering result of the grid to show up in cell A of my layout. And I need the 2nd filtering result of the grid to show up in cell B of my layout.
For example, suppose I have a column in my grid where I input a color. I need the grid with rows including the color red to show up in cell A of my layout. And I need the same grid with rows including the color blue to show up in cell B of my layout.
I know how to filter the grid, and I know how to attach the grid to a cell in my layout, but I cannot figure out how to have 2 separate instances of the grid be attached to 2 separate layout cells.
Can this be done? Thank you.