Hide Column when values = 0.

[Former Member]

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

[Former Member]

Hi ,

In Query designer -> Query Properties tab(near check query) go to rows/columns tab -> you will find the suppress Zeros option ->Select Active-> select columns their save and run your report .

[Former Member]

Hi Amrita

The process you mention is it will only hide the values not heading of the column

But My requirement is when the values = 0 , I don't want to display KEY FIGURE ( I mean Heading) also.

Regards

Sree

[abhishek_rajan3]

Hi Sree,

What Amrita mentioned would suppress the heading for that particular key figure column as well (Just select Active (All Values = 0). That means it does suppress the entire column.

Hope this is what you require. If you mean otherwise, please elaborate.

Thanks,

Abhishek.