Set analyser calculate 1 field based on other filtering

[Sir_Johanos]

Hello, 

Need help.

I have table

[ type, code , name,sum

1, 1, Mark,3

1, 2, John,4

1, 2, Anna,5

2, 1, ,15

2, 2, ,18

3, 3, ,20]

So, i want calculate Sum of type=2 , but if we make filter Anna  in result i want 18 because Anna has code 2,

if in filter we take Anna and Mark in result I want 15+18? because they have code 1 and 2

Any idea?

[tresesco · Accepted solution]

If understood right, may be this:

=Sum({<name,type={2}, code=p(code)>}sum)