Help with sum min / max

[#1]

Hi,

i alrady tried some suggestions in this forum but can not solve my Problem.

Name	Number
A	1
B	2
C	3
A	4
B	5

Now I need the sum of the min of each name

min A = 1

min B = 2

sum = 3

I have tried something like this: min(aggr(min([Number]),)) but it doesnt work...

Thanks!

[nirav_bhimani]

Hi,

Try this,

=Sum(aggr(Min(Number),Name ))

Regards,

Nirav Bhimani

[#3]

thanks - but it seems that it does not work this way..

[#4 · Accepted solution]

Thanks for your Help! I think i've got it:

Sum(Total<Number> aggr(Min(Number),Name))