Problem in Calculation

[#1]

hi m stuck off facing the problem but can't get success

please help me.

see the data of my table like this

MAT_CODE	MOV_TYPE	SALES
A	0	100
A	1	200
A	2	300
A	5	400
B	8	500
B	9	600
C	0	700
C	5	800
C	3	900
D	7	1000
D	10	1100
D	2	1200

Now i want the output like this

MAT_CODE	SALES
B	1100
D	3300

here i clarify to you that i want those MAT_COD that don't have MOV_TYPE  equal to 0  and sum total of that SALES with MAT_COD

any help will be appreciated

[#2]

hiii sir, flipside

you are right regarding to selection in list box the data comes all rather than to show selected value for resolving this problem i have done in calculated dimension like this

aggr(only({<MAT_CODE -=p({<MOV_TYPE={0}>})>}MAT_CODE),MAT_CODE)

and same expression as told by sir Gysbert Wassenaar

Regards

vishwaranjan