How to Hide a Complete section when no values and How to Replace zero values with Null values
My webi Report is based on many sections(section is applied on Cost Centres) at present in my report for some of the measure column vlaues are showing '0's and for some measure columns showing empty(which means Null).
But my user's wants
1-->Hide the section when that section doesn't have any values for all the columns and their totals.
2-->Where ever the section values are showing 0's it should replace with Null values(which means it should display empty in place of 0's).
My Webi Reports are created on top of BICS Connection.
Appreciate all your inputs on this.
Thanks & Regards,