How to limit rows in table by Measure amount

[#1]

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

[rubenmarin · Accepted solution]

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

[#3]

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

[vinieme12]

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

[#5]

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.

[vinieme12]

correct

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