Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
My requirement was to alternately strip rows but only for specific columns in a straight table, so I can delineate particular columns from others but retain the stripe effect.
I used the expression:
=If(Even(RowNo(TOTAL)), rgb(220,220,220), rgb(238,233,233))
This works sort of but with the problem that all values including zero values now show for that expression even though I have suppress zero values ticked?
Can anyone advise why and how I might fix this?
Thanks
Dominic
Please can anyone help?
Thanks
You can enable striping on the Style tab and custom format the cell background colors. Or you can use a calculated dimension. See attached example.
For the custom formatting you need to enable the option Always Show Design Menu Items on the Design tab of the user properties window. With this enabled you can right click a cell and choose Custom Format Cell.
Hi,
You can able to use this condition in dimention field bg area. see the below screenshort
else.
Use Gysbert Wassenaar way.