show/hide the Rows

[Anonymous]

Hi,

Here am using variables for Stretch and RPI. If stretch and RPI is "No", then it will show the value as 0. So i want to hide the rows when it is showing '0'. since in presentation tab i checked supress zero values.

Please someone help out to achieve the same.

Thnks,

Nisha loganathan

[ashfaq_haseeb]

Hi,

Go to Chart properties --> Expression tab --> Select your Expression check conditional and write If(Stretch>0).

Regards

ASHFAQ

[Anonymous]

Hi,

Thanks for your reply. But when am doing as per what yo said, that record is not showing but at the same time i want PIP row fully. When am doing like this , PIP value 10 is not showing.

i attached the application for your reference.

[ashfaq_haseeb · Accepted solution]

Hi,

Check this.

Regards

ASHFAQ

[Anonymous]

Hi,

Thank yo so much. It helped me a lot