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