Grouping Rows and Columns

Hi just wondering if anyone has tried to do something like this

where the rows are collapsible and also the column, but still it has this clean look.

Yep — as long as those are cells there and not just the summaries of collapsed groups (because you cannot conditionally format the summaries).

You basically need to generate yourself a separate table where each row is a unique combination of a property to the left (cashflow prop) and the property to the top (month), then calculate those numbers with a formula.

It won’t be that collapsible though: e.g. you cannot build this directly on the table of transactions and make the summaries formatted. You can only conditional-format data cells, not group summaries.

P.S. Another thing that you can do is generate a not-a-model table (I call these report tables) and be creative with what you do with your rows and columns altogether — basically replicate spreadsheet logic with it:


This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.