5 Replies Latest reply: Jul 22, 2016 4:06 PM by Vineeth Pujari

# How to limit rows in table by Measure amount

I have a plain table with number of calculations around sum(Amount) grouped by different time period, so basically it's plan table, how I can show only rows where let say  sum(Amount) > 0  (I still have records with 0 o negative amount),  I can't eliminate them on data load step.

I don't see any filters neither on Dim or Measures,   thanks for help.

Vic

• ###### Re: How to limit rows in table by Measure amount

Hi Viktor, maybe you can create a calculated dimension that only shows values wich meet the criteria, like:

Aggr(If(Sum(Sales)>0, Customer), Customer) // It will list only customers with Sales>0

• ###### Re: How to limit rows in table by Measure amount

Thanks much Ruben,

It worked OK, I create this cond dim (I assume it's just conventional Dim with function in def), and then after uncheck <remove NULL> that raw gone!

I'm bit still confused with tranlation of this f:

Aggr(

if(Sum(Sales)>0, Customer), Customer  // if sum(Sales) > 0 then dim on Customer, if not then still Customer ??

)

Thanks much again.

V

• ###### Re: How to limit rows in table by Measure amount

The AGGR function will check for each Customer if sum(sales) >0 and return Customer if true , else null().

• ###### Re: How to limit rows in table by Measure amount

Thanks Vineeth!

And  I see that after that you need to uncheck <Show null values>, at least for my case as I have some joins.

• ###### Re: How to limit rows in table by Measure amount

correct

and you need to Check "Suppress when value is null" on the dimension