filtering rows according to an exprssion

[m4u]

hi all,

i have a "straight table" with some dimensions, and 2 expressions:

Sum(CurrentItems)

sum(CurrentValue)

i want that when the first exprssion returns zero, the row will not appear on the table.

thakns for any Idea.

shlomo

[matt_crowther]

Create a Calculated Dimension something along the lines of:

=if(sum(CurrentIrems)>0,[Name of Dim])

Then set the dimension to 'Supress Where Null'.

That should do it.

Hope that helps,

Matt - Visual Analytics Ltd

[m4u]

Hi,

thanks

when trying to use an aggresation function (like sum(xxx)) as a dimension, the result is:

"// Error in calculated dimension"