Problem: Secondary column in a Parent-Child Hierarchy Chart of Account

[mrvoorhees]

I'm working on a Chart of Account and I'm having troubles to display a secondary column with the name of each account (or visible account). So far, I achieved a parent-child hierarchy showing the account code column with its values. But, I also need to show the name refered to each code. So, basically, I have a parent-child hierarchy and I need display "account code", "account name", "value" (in different columns).

Columns:

Account code = CODIGO

Account name =  DENOMINACION

Values = AMOUNT

This is what I have:

And this is, sort of, what I'm looking for, but using p-c hierarchy.

When I try to put "DENOMINACION" (account names) into values grid, they appear at every hierarchy level, even duplicating names. I need to figure out a way to display the name only at the visible levels with values on it, or even the complete name list but without duplicates.

Thanks in advance!

[mrvoorhees]

Here's a sample data: https://drive.google.com/file/d/15q_S01IPwhH6JA_5K6RMCG5fL4TRc1Vj/view?usp=sharing