Formatting

[anom23]

I have a been stumped on a problem which seems more difficult that I thought it would be.  I have a set of data which I would like formatted where the Client totals are grouped by subtotals and totals (see excel).  Is this possible?  I have tried adding additional rows using the multirow tool and then union the original data but nothing works.  I have attached a mocked up flow.  

[Qiu]

@anom23 
Maybe you can check the posts here.

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Merging-cells/td-p/1045262

[Yoshiro_Fujimori · Accepted solution]

Hi @anom23 ,

With the configuration of Table tool, we can do almost anything (if you do not care about the workload 😅)

I tried to follow the expected output as much as possible.

You can add more conditions of Columns / Rows as needed.

(e.g. erase the CLIENT_NM texts except for the first rows and total rows.)

I hope this helps.

But I would rather use BI tools (Tableau, Power BI etc.) to beautify tables ...

Workflow

Output

[anom23]

Thank you  that worked