So I've been working on my tables and have built up a ton of tables, some with rollups, and some without.
My issue is that I cannot rollup a rollup from another table, so I need a formula to replicate that data.
I've been looking at Thomas Frank's video on the formula masterclass 2.0, and that map function looks good, but I cannot sum up data for the relevant field.
I have prop("Total Order Value") which is a summed-up column from my "Orders" table. How do I create a formula for this? I think if I knew this method I'd avoid rollups altogether.