Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to look at the sum of the maximum sub section.
e.g.
Section | SubSection | Value |
---|---|---|
1 | 1a | 100 |
1 | 1a | 10 |
1 | 1b | 200 |
1 | 1c | 200 |
1 | 1c | 10 |
So the value i would expect to see would be 210 which is the total of subsection 1c rather than the max the whole section.
Thanks in advance!
try:
Max(Aggr(sum(value),SubSection))
Please find attached
HTH
Sushil