Filter records

[GraceGao]

Hi Experts,

i have measure, i would like to display only measure value <1 in table. could any one to help? 

[msKarthikeyan]

Hi Grace,

You can add this in dimension 

=if(aggr(sum(Measure),Dimension)<100,Dimension,Null())

and uncheck include null values

-Karthik