Formatting Alteryx Tables

[RonGatmaitan]

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.

[mceleavey · Accepted solution]

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.

[RonGatmaitan]

Hi @mceleavey,

Trying this now.

Thank you very much!

P.S. Would it be simpler if we removed the Grand total below?

[mceleavey]

@RonGatmaitan ,

It's up to you. You can just drop that if you want. Remove it from the union and it won't appear.

M.

[RonGatmaitan]

Thank you very much, @mceleavey! Marking this as a solution. Very useful for future reference.