Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ??
Try maybe like attached
Try maybe like attached
That's the right solution
I have another levels and info, but using your example, i got the right results
Thanks a lot Swuehl