Expression help please

[#1]

ID	TYPE	AMOUNT
1	RENT	400
1	RENT	200
1	DEP	300
1	DEP	300
2	TAX	100
2	TAX	200
2	RENT	400
2	RENT	100
	For each ID I have to get the max of amount of each type and then sum it..
	Here Ex: ID =1 ,Max(Rent) =400
		Max(Dep)= 300
	For ID =1,Amount is 700

Thank you very much .

[sunny_talwar]

May be this:

Sum(

          If([Expense Month-Year] >= date(Today(),'MMM-YYYY'),

               If([Expense Month-Year] <= date(AddMonths(Today(),12),'MMM-YYYY'),

               Aggr(

                    (Max([Amount of Expense]) * Pick(Match(pay_frequency, 'MONTHLY', 'QUARTERLY', 'ANNUALLY', 'SEMI-ANNUALLY'), 12, 4, 1, 2)),%SubspaceKey,[Expense Type]))))

[#3]

Thank you very much...it made wonders