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.
Here's a suggestion. General Lists in rows are Revenue, Country and New Biz. For illustration purpose I have Line Items in columns but you'd probably want to have them on page instead to display only Rev Tot Old Biz.