set analysis

[JMAROUF]

Hi everyone,

i want to sum sales of salers whose sales are equal to 10367007,4265, i have tried this:

=sum({1 <SalesPersonID={"=sum(SubTotal) =10367007,4265"}>} SubTotal) 

but it doesn't work, 

my goal is to understand advanced set analysis, can any one help please?

PS: it's possible with p() function? 

Best regards.

[Saravanan_Desingh]

Try this,

=sum({<SalesPersonID={"=Match(sum(SubTotal),10367007,4265)"}>} SubTotal) 

[Denisg]

Hi,
Or this one:
=Sum({<[SalesPersonID]={"=Sum(Distinct SubTotal)=10367007,4265"}>} SubTotal)

[Vegar · Accepted solution]

It could be the decimal separator that is the issue.

Try changing  from comma to dot for your comparison number, like this: 10367007.4265

[JMAROUF]

@Saravanan_Desingh , @Denisg ,

thank you for the reply, the the both solutions didn't work. here is my model, any help plezase.