Multiple filters in dataset with AND & OR conditions
My dataset looks something like this with lot many rows. I want to find the sum of troops A has with Support (Support is Y) and for only XYZ and MNO Cities.
I have tried something like this
when support = y then
case when city = MNO or city = XYZ then
I use both or & and at the red colored portion above but I was not able to get the required number.
Please help me