Changing the look of data before Render tool

[Rugglesr]

Hello,

I have a report that I am running that counts data based on types and sub topics. I would like for them to be ordered like this:

I  for the life of me can not figure out how to accomplish this, when I try to arrange it it ends up looking like this:

Anyone able to suggest how I can get it to this format?

[afv2688]

Hello @Rugglesr ,

Here you have, working like a charm. :)

Cheers

[Rugglesr]

Hey a@fv2688

Thanks for the previous help, that Macro works on another report I am making, but with this one it has a unique name for each Task (previously named type) for each Subtopic. I noticed you filtered via the Type1 name but after playing with the macro could not figure out how to change it. Please see the attached example workflow, looking to get the same result as before.

[afv2688]

Hello @Rugglesr ,

The schema changed pretty much yes. Here it is. I hope it is what you were looking for.

Cheers

[Rugglesr]

Hey @afv2688,

Thanks this worked, now I need to ask how we include the count, I tried adding a summarize in but then it starts us back at square one. Also, Subtopic should be where field1 is as the parent and field1 should be the child.

Like this:

Subtopic

        field1

        field1

I am completely new to Macro's and Alteryx so I tried to play with what you provided but have had no luck.

Thanks again for the patience and help!

[afv2688 · Accepted solution]

Hello @Rugglesr ,

Is this what you were looking for:

I added the sum of the totals per task on the same row

Cheers

[Rugglesr]

That is perfect! Thanks again for all you your amazing help!

[afv2688]

You are welcome :)

If you don't mind, would you please mark it as solved. Helps the community to find the solutions faster in the forum

Cheers