How to give Back ground colour on a specific item

[nevilledhamsiri]

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

[andrey_krylov]

Hi, maybe this...

[nevilledhamsiri]

Mine is a personnel edition. Could you please sow it on the body of the reply

[andrey_krylov · Accepted solution]

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

=''

[nevilledhamsiri]

Thanks a lot Andrey. This is fine.

Good luck

Neville