Don't summated values in pivot table parent key

[#1]

Hello.

I have the flollowing table structure:

I made an pivot table with:

Dimensions - "PARENT" and "NODE".

Expression - Sum (Value).

And the result is like this:

How to make the result be:

If i made the table structure to be like this:

It mess it up with the structure making two structures one with any nodes and the correct value and another summated with the value 497,

I'm not figuring this out, anybody know how to not summate in the first dimension and lookup for the value with the KEY?

Thanks!

[#2 · Accepted solution]

Just figure it out.

1 - Table with key / parent / node with the value of parent.

2 - The Set analysis was if node = parent then make the sum:

If ( Dimensionality() = 1,

  SUM({$<[Período - MES (seq)] = {1}, [pk_setor] = p([Setor - GNV])>} [Valor_Add])

If ( Dimensionality() = 2,

  if( [pk_setor] = ([Setor - GD]), 0,

SUM( {$<[Período - MES (seq)] = {1} >}[Valor_Add]) 

)

))

3 - Hide values = 0 so the parent don't get showed in the node tree.

I dont if this was the best choice but it works.

Hope it helps.

Best regards.