Formatting

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.

Developer

Transformation

Accepted answers

Yoshiro_Fujimori

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

All comments

@anom23
Maybe you can check the posts here.

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

Yoshiro_Fujimori

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

Thank you that worked

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703