calculate sum of amount for below

[#1]

Hi Guys

Can any help me on this

I want to calculate the sum of X and Y,

Header 1	Header 2	Header 3	Header 4	Header 5
Project Code	Rej_code	Task ID	X amount	Y amount
12345	AAAA	auto generated	100	101
	BBBB	auto generated	102	103
	CCCC	auto generated	104	105
	DDDD	auto generated	106	107

As explained in above table   for Project code have 5 REJ CODES and task id is auto genrated. Here I want to calculate X amount which is related to REJ code AAAA or BBBB and TASK ID matches the REJ code AAAA or BBBB.

Same case to calculate Y as well.

Please help me

Thanks

Srini

[sunny_talwar]

May be this:

Sum({<Rej_code = {'AAAA', 'BBBB'}, TASK_ID = P({<Rej_code = {'AAAA', 'BBBB'}>})>}[X amount])

Sum({<Rej_code = {'AAAA', 'BBBB'}, TASK_ID = P({<Rej_code = {'AAAA', 'BBBB'}>})>}[Y amount])