Can you consider adding the ability to filter Grid Rows or at least hide grid rows that I do not want to be seen. I am looking at a scenario where I would be creating dynamic reports using grids that pull information from Tables using formulas. However I would want to be able dynamically to filter out unwanted information from the Grid report using preset filter parameters.
See simple example in picture below
Feels like this is a use case for a regular table – out of curiosity, why is the grid the solution for you in this case? Is it a aesthetic issue?
Yes it is for better Aesthetics. A regular table will not achieve what I want. In my grid report, the Table columns become my rows. If there was a way to transpose the table, it might work but i would still need the ability to filter or hide the rows
You would need to dynamically create this table with a formula – like a helper table, that you recalculate every time you need it with a click of a button.
That maybe could work.