Changing the look of data before Render tool

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?

Tips and Tricks

Accepted answers

Hello @Rugglesr ,

Is this what you were looking for:

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

Cheers

orderFiles.yxmd

orderfile macro1.yxmc

All comments

Hello @Rugglesr ,

Here you have, working like a charm.

Cheers

orderfile macro.yxmd

orderFiles.yxmd

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.

Example-Workflow.yxmd

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703