I want to add a condition on a dimension value where it should not be affected by any other dimension selection. Below is an example for the same.
Name
Salary
Dept
N1
100
D1
N2
200
D2
N3
120
D1
I want to show all the names in the dimension irrespective of the "Dept" selection made. The Dept selection should only filter the calculation made in the Salary column.
