Maximum Value

[#1]

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!

[sushil353 · Accepted solution]

try:

Max(Aggr(sum(value),SubSection))

Please find attached

HTH

Sushil