Alternate Colouring of Group of Rows

[#1]

Hi All,

I have a pivot table in the attched qvw.I want alternate colouring of the row groups according to the first dimension.

I have searched in community and used the following expressions for background colour

if(even(aggr(RowNo(),Field)),LightGray(200),Yellow(100))

if(even(max(total <Field> aggr(RowNo(),Field))),LightGray(200),Yellow(100))

Unfortunately these expressions are not working properly in my application attached.

Please help me where I am going wrong.Thanks

Regards

Murali Krishna

[nizamsha]

PFA

[preminqlik · Accepted solution]

hi

Please find attachment

[#4]

Hi PremKumar,

Many Thanks for your reply.It worked like a gem

Actually the above expressions which I posted in my post are also working .Problem lies in Sort.

Regards

Murali Krishna

[#5]

Hi PremKumar,

I am still facing with two problems.

1) I need A -> Z sorting of my first dimension.Is it possible ?

2)When I select multiple values of my first dimension in listbox colouring of alternate rows is not working properly.

Please find teh image attached.

Many thanks for your help and time.

Regards

Murali Krishna

[preminqlik]

hi

QUIT BUSY , YOUR EXPRESSION IS WORKING FOR BOTH SECOND AND THIRD COLUMN

WILL C IN NIGHT

[preminqlik]

hey , here we go

write this expression , this is dynamic

=if(even(aggr(nodistinct RowNo(total),LAB_VENDOR_NAME)),LightGray(200),Yellow(100))

find attahment

-Premhas

[#8]

Hi PremKumar,

Thanks it is working now dynamically also.But still i have a problem with sort.

When I remove teh sort expression which you have given and use A -> Z sorting (Which is my requirement) .Colouring is again not working properly

A -> Z sorting of my dimension is not possible?

Many thanks for your help.

Regards

Murali krishna