Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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