distinct of Sum

[Anonymous]

I am trying to find out how many distinct SUM of point each Nmae has

I am getting: Error in expression Nested aggregation not allowed  when trying : Count(DISTINCT(sum(Point)))

I tried various use of aggr but I have not yet found the solution.

Any idea?

for example for:

I would expect to see:

[Anonymous]

3 and 3

[Anil_Babu_Samineni]

If you look data, You will understand the Result

[Anonymous]

No ,

Should be

A = 3 as  over the period there were 2 distinct Sum 400002 ,3, 6

B = 2  as  over the period there were 2 distinct Sum 12 and 600007

[Anil_Babu_Samineni · Accepted solution]

May be this?

Count(Aggr(Sum(TOTAL <Date> Point), Date, Name))

[Anonymous]

Thank you!