Forum Discussion

Irene_B's avatar
Irene_B
New Member
4 years ago

Filter a no-interaction Table

Hi all,

 

I am struggling with this:

I have the field X, which can be "A", "B" or null and a series of measures that for semplicity I will call Measure Y. When Measure Y has values, Measure Z and Field X aren't:

Obs Number

Field XMeasure YMeasure Z

Obs 1

null

10 
Obs 2null15 
Obs 3null20 
Obs 4A 25
Obs 5B 10

 

I need to have Field X as a filter and as result a table, that can be:

 

Field X: A

sum(Measure Y)sum(Measure Z)
4525

 

or

 

Field X: B

sum(Measure Y)sum(Measure Z)
4510

 

I tried to remove interaction from the filter to the table, and that works with Measure Y, but I get also 35 as a sum of Measure Z. 

Is there a way to keep the filter just on Measure Z?

 

Thanks a lot!

Need Help

2 Replies

    • Irene_B's avatar
      Irene_B
      New Member
      4 years ago

      Hi Greg_Deckler , thank you for the answer. I fogot to mention the I also have others filters aldready included in the Measure Z calculation (it is a Calculate(sum(measure), filter (etc.))). And also other filters not in the calculation but in the viz, for wich I want to mantain the interation. 

      For Measure Y it'the same. 

      Thanks again!