[Help] How to distinguish the same category between different subtotals

[msyosd]

Hi Alteryx experts,

I would like to seek your help on appending prefix or suffix to duplicated accounting categories under the different subtotal categories in the attached sample data.

As you can see from the "Before," we have identical accounting categories, but I would like to somehow distinguish them between Sales and Cost, like the ideal output in "After."

Thank you so much for your attention and advice.

↓

[atcodedog05 · Accepted solution]

Hi @msyosd 

Here is how you can do it.

Workflow:

Hope this helps : )

[msyosd]

Thank you for such a quick and beautiful answer!!

[atcodedog05]

Happy to help : ) @msyosd 

Cheers and have a nice day!