Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Formatting Alteryx Tables

RonGatmaitan
8 - Asteroid

I have a table that looks like this.

 

RonGatmaitan_0-1640087622793.png

 

I'm trying to format is such that it looks like this.

 

RonGatmaitan_1-1640087677205.png

 

I tried to use the Basic Table, and every time I group by A and B, the values disappear.

 

Help, please.

4 REPLIES 4
mceleavey
17 - Castor
17 - Castor

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:

 

mceleavey_0-1640089399172.png

 

 

mceleavey_1-1640089580980.png

 

I hope this helps,

 

M.



Bulien

RonGatmaitan
8 - Asteroid

Hi @mceleavey,

 

Trying this now.

 

Thank you very much!

 

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

mceleavey
17 - Castor
17 - Castor

@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.



Bulien

RonGatmaitan
8 - Asteroid

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

Labels