table requirement

[#1]

Hi,

   How to remove row in straight and pivot table, if the Amount column has Zero values.

Thanks,

MLNR

[alexandros17]

If Amount is the only expression then in Presentation check the box "Suppress Zero Values" otherways tell me more about dimensions and expressions

[its_anandrjs]

Hi,

In the Expression use conditional option and write

Ex:-

Suppose your expression is Sum(Amt)

if(Sum(Amt) =0,0,1)

Regards

Anand

[its_anandrjs]

And if it is dimension then write

Ex:-

Click on Enable conditional

if(IsNull(Amt ) = 0,0,1)

Regards

Anand

[Anonymous]

Hi,

for pivot table you can restrict in expression-Conditional: (=sum(Sales)>0).

In straight table Presentation- condition: if(Sum(Actual)>0,1,0)

Regard

Arun