Change Dimension Background

[#1]

Hello Friends,

We have 3 fields Week, Date and Event (which is associated to a date).

Our requirement is crosstab having Dimension as Week which need to be highlighted when event is present (but date and event are not taken as dimensions).

Please find the attached screenshots for reference.

Week 1 and 3 should be highlighted with a color.

Thanks in Advance,

Siva Srinivas.

[maternmi]

Hi,

--> chart properties

--> expression

--> week properties, open by clicking on plus

-->background color

-->write the formula: if([event] <> 0, green(255))

hope that helps you!

BR

Michael

[vipin_mishra479 · Accepted solution]

Hi Siva,

Use This in Dimension

if(len(Event)=0,White(),Green())

Vipin

[#4]

Thanks Michael and Vipin for your Quick responses.