I have a table that looks like this.
I'm trying to format is such that it looks like this.
I tried to use the Basic Table, and every time I group by A and B, the values disappear.
Help, please.
Hi @RonGatmaitan ,
The problem you're having here is that is no longer a table, as you have broken the column structure. It's like you're going back to reporting in Excel.
However, there are ways around this but it's a bit fiddly.
I've built the following workflow, which creates the calculations and puts them into the correct columns, then the grans total is merged as a separate table. You can mess around with the borders etc to make it merge together, but the basics are done for you:
I hope this helps,
M.
Hi @mceleavey,
Trying this now.
Thank you very much!
P.S. Would it be simpler if we removed the Grand total below?
@RonGatmaitan ,
It's up to you. You can just drop that if you want. Remove it from the union and it won't appear.
