Expression within a set analysis

[vidamakiling]

Hi, thank you for taking the time to read my question.

I have this data set below:

EmployeeID	Hour1	Hour2	Salary
1	-5	0	500
1	5	0	250
2	0	1	700
3	0	0	500
4	2	0	250
4	3	0	700
5	5	0	500
5	-2	-1	250
5	-3	1	500
6	2	0	250
6	-2	0	700

And what I'd like to happen is to display only that has a total of 0 for Hour1 and Hour2 and display the sum of the salary as well. Below is the desired result:

EmployeeID	Hour1	Hour2	Salary
1	0	0	750
3	0	0	500
5	0	0	750
6	0	0	950

Here's what I tried to use:

Sum({<Hour1 = {"=sum(Hour1)=0"},Hour2={"=sum(Hour2)=0"}  >}Salary)

But obviously, it is not working. Appreciate your help!

Thanks in advance! 

[marksouzacosta]

@sunny_talwar now I agree 100% with you.

[vidamakiling]

Hello,

What if some of the values are negative?

Right now it gave me this:

EmpID      Hour1     Hour2    Salary

1                  -5              0              750

1                   5              0               750

2                   2               0              950

2                   -1              0              950

2                  -1               0              950

This is just an example unrelated to my original post. I used the expression within a set analysis but what I'd like is for it to display like this

EmpID      Hour1     Hour2    Salary

1                  0              0              750

2                  0              0               950

Thanks!

[marksouzacosta]

This one you can solve just adding a straight chart using two dimensions and two measures: