Filter a pivot by a column expression

[#1]

hi

i have a pivot with 3 columns A,B,C and C=A-B.

i want load the row into a pivot if C>=0, is possible?

thanks

[Anonymous]

Could do something like

if( C>=0, C)

In this case the values which are not in the C>=0 are a null value ...

If this is the only expression the null rows shall not be displayed.

If you have other expression fields you should add the if aswell, to make the value null if not C>=0 ...

In this case this row is not displayed.

Don't know if this is what you exactly need ... and don't know if this is the nicest way of doing it ... but it could do the trick.

Anita