Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
If understood right, may be this:
=Sum({<name,type={2}, code=p(code)>}sum)
If understood right, may be this:
=Sum({<name,type={2}, code=p(code)>}sum)