How to sum with filtering data
I have some data as per below table.
|Rev b||Hong Kong||N||2,000.00||3,000.00|
|Rev d||Hong Kong||N||2,000.00||4,000.00|
I would like to sum the revenue by country and month as well as filter out the new biz = Y. Answer: China: Jan revenue = 4000 and Feb = 5000 Hong Kong: Jan revenue = 4000 and Feb = 7000 Would appreciate your advice how to do the formula so that module is able to compute the revenue as per above answer.Thanks.