Skip to Content
0
Jun 15, 2011 at 07:26 AM

Re: Hide Column when values = 0.

14 Views

HI Experts,

I need a report when ever In a column all values equal to zero(=0) the entire column has to hide(Including Header).

Is there any possibility.

For Ex:

ccode: dchannel:sal_total: sal_profit:

1000 !!!! D1 !!!! 1000 !!!! 0

1000 !!!! D2 !!!! 2000 !!!! 0

1000 !!!! D3 !!!! 3999 !!!! 0

If this is the data available in the cube.. The report in the analyzer has to be..

ccode: dchannel: sal_total:

1000 !!!! D1 !!!! 1000

1000 !!!! D2 !!!! 2000

1000 !!!! D3 !!!! 3999