How to filter rows on a table

[jcarloscandela]

Hello,

I'm a bit newbie and I'm trying to filter a table, taking only the rows when NPS > NPSb

I only want to show these rows

Which is the best way to do it without modify the Load Script?, Should I create a Calculated Dimension? or Is it better to use a measure? 

Ty

[VishalWaghole · Accepted solution]

Creating only one expression as below,

If(sum(NPS)>sum(NPSb), sum(NPS))

Regards,
Vishal

[jcarloscandela]

I tryed it before, but I want to hide the Null values, It is possible to hide null values in a expression?

[VishalWaghole]

Go to chart proprties, under both dimensions you will get option as Include null values, just uncheck it.

Hope this will work for you.

Regards,
Vishal