1. I have raw data as & sample as attach file
2. Table raw data just show all data
3. Table 2 Show Member
4. Table 3 Need help, find active member condition is 4.1 [Member Status] =1 4.2 sum(Sale) >0 If you have any question please let me know.
Try this expression
=If(aggr(([Member Status]=1) * (Sum(Sale)>0), [Member ID]),
View solution in original post