show only certain rows in straight table

[ioannagr]

hello all

I have the following straight table:

dimension,   measure 1, measure 2

I want to show everytime, those rows, when measure 1 and measure 2 are not null .

How do i do that please?

Thank you 🙂

[Taoufiq_Zarra]

@ioannagr  do you have a sample data to see

[Kushal_Chawda]

@ioannagr  you can create calculated dimension like below

= aggr(if(measure1 >0 and measure2>0, Dimension),Dimension)

Replace measure 1 & measure 2 with actual expressions of measure 1 & measure 2

[ioannagr]

@Kushal_Chawda  excuse my ignorance, i've never done this before, where do i put this ?

[MayilVahanan]

Hi Ioannagr,

In the Dimension tab, you can use the expression given by Kush.

aggr(if(measure1 >0 and measure2>0, Dimension),Dimension)

and "check the suppress when values is Null" checkbox .

Hope it helps

[ioannagr]

@MayilVahanan hi, i don't have a suppress when values is null, only include null values which i unchecked!

is it okay?

[MayilVahanan]

Hi @ioannagr 

Can you provide the sample file to understand better or screenshot?

[Kushal_Chawda · Accepted solution]

@ioannagr  you need to put this expression in Dimension,

aggr(if(measure1 >0 and measure2>0, Dimension),Dimension)

and uncheck "Include null values"

[ioannagr]

Thank you all, I just gave @Kushal_Chawda  the solution because of his speedy answer, but thank you guys  lots as well 🙂