Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a strait table with one dimension. I need to hide rows from the table, based on expressions values which are calculated based on fields that different from the table’s dimension. Any ideas?
Thanks
Hi
Try with aggr() function in expression.
hi,
i have "store #" as the (only) dimension of the straight table. the expressions are sum(inventory) and sum(sales), were "inventory" and "sales" are fields. i need to hide all the rows with both sum(inventory)=0 and sum(sales)=0, and all the rows with "store #" <500. any idea how to achieve that?
thanks
Hi
For that, try like this
Exp1:
= if(Sum(Sales) <> 0 and Sum(Inventory) <> 0 and "store #" < 500, Sum(Sales))
Exp2:
= if(Sum(Sales) <> 0 and Sum(Inventory) <> 0 and "store #" < 500, Sum(Inventory))
Hi Danny,
Try like this
Exp1:
= Sum({<[store #]={'< 500'} >}Sales)
Exp2:
= Sum({<[store #]={'< 500'} >}Inventory)
and then in Presentation tab select "Suppress zero values" option.
Regards,
Jagan.