Conditional Sum based on a flag/dimension

[meg007]

I want to find the sum of sales based on a flag

contract flag - N/Y values

sum of sales when contract = N

[sunny_talwar · Accepted solution]

Try this

Sum({<Contract = {'N'}>}Sales)