Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
By using CTRL+G, I tried to give a back ground colour on account code 80670, but what happen is, entire list of account codes get coloured instead. Is there a way forward to make it coloured?
Also is there a possibility of adding an extra column with no dimension in order to make the table clear. As per the attachment , can an extra column be added between motor & non motor expense
Thanks
Neville
Yes, in chart properties - Used Dimensions - Background Color add expression
=If(ACCOUNT_CODE = '80670' and Dimensionality() <> 0, LightGreen(), White())
but for clear column maybe to add a calculated dimension
=''
Hi, maybe this...
Mine is a personnel edition. Could you please sow it on the body of the reply
Yes, in chart properties - Used Dimensions - Background Color add expression
=If(ACCOUNT_CODE = '80670' and Dimensionality() <> 0, LightGreen(), White())
but for clear column maybe to add a calculated dimension
=''
Thanks a lot Andrey. This is fine.
Good luck
Neville