How do I get a different value to the current row in a flat table

[#1]

Hello everybody

I have a table with values, levels, descriptions, etc.

In this example i need to know in every level 3, the value of their level 1

I tried with

If( nivel = 3, Aggr(NODISTINCT Sum(Cantidad), P1N3, Estado), 0)

In the first group, the quantity is correct (201,340,001)

But in the second group is wrong (31,442,845) must be (80,333,635)

The difference is cause the last level 2 does not have a level 3 (48,890,790)

I've been trying different ways but I can't get the right result

What do you think, is this possible ??

[swuehl · Accepted solution]

Try maybe like attached

[#3]

That's the right solution

I have another levels and info, but using your example, i got the right results

Thanks a lot Swuehl