Color header in pivot table

[inescastelhano]

Hi folks,

I'm trying to color either the header or the entire column (it doesn't really matter), if the weekday is saturday or sunday. I have the following table, and the following table expression:

=(round((hour(sum({<Day=,[Day of the Week]=>}aggr

(max({<Day=,[Day of the Week]=>}

[time1]-[time2])

, [ID])

))*60+minute(sum({<Day=,[Day of the Week]=>}aggr

(max({<Day=,[Day of the Week]=>}

[time1]-[time2])

, [ID])

)))

/count({< Day=,[Day of the Week]=>}

[Day])))

I'm using this expression to try to color the columns, but it's not working:

if(only({<Day=>}[Day of the Week])='sunday',

RGB(0,0,0))

Any help?

Thanks in advance!

Cheers,

Ines

[Chanty4u]

u can use  custom format cell..

there u can give any colur to any cell of ur table.

go o  -->view tab---?select --->grid view--->select ur table--->right clik---->select ur cell and give colur

[inescastelhano]

Hi, Actually not, because with custom format cell, conditional formatting is not possible.

Thanks

[#4]

Hi,

Can you try following expression in background color

if(Match(Only(total<Day>[Day of the Week]),'sunday','saturday'),RGB(0,0,0))

Regards,

Nandkishor Pandirkar

[inescastelhano]

Hi!

Thanks for your reply, but it doesn't work

Cheers,

Ines

[#6]

Can you attach sample qvw