Condition on group by (aggregate)

[jjustingkm]

Region	SalesID	TRID
North	100	1001
South	100	1002
East	101	1003
West	102	1004
West	102	1005

I am trying to get here is the total  TRID for each sales id where count trid =2, here sale id 100 and 102  have count(trid) =2 , total trid =4.

I wrote something similar to this , but not working, Any help would be really appreciated.

Sum(Aggr( If(count(DISTINCT trid)=2,count(trid),0), saleid).

[starke_be-terna]

Hi @jjustingkm!

I would try to solve this using Set Analysis and Advanced Search. Try this:
count({<SalesID={"=count(TRID)=2"}>} TRID)

Best regards
Benjamin