hide rows

[#1]

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

[MayilVahanan]

Hi

Try with aggr() function in expression.

[#3]

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

[MayilVahanan]

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))

[jagan]

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.