Not showing zero values when using {1} set Analysis
Hi all,
I have a pivot with 1 dimension and 2 Measures:
[MyDimension]
Measure1= Sum(Field1)
Measure2 = Sum(Field1)/Sum({1} Field1)
The problem is: when I select a field in MyDimension, I still see all other values in the pivot but with zeros as result of the measures.
When I remove the Measure2 from the pivot, instead, After selecting the value from the dimension [MyDimension] I see only the single row corresponding to it.
How can I include the Measure2 without seeing the zeroes??
Note, "Measure2 = Sum(Field1)/Sum({<MyDimension = >} Field1)" is not working, even if is the theoretically solution to this problem
