change the background color of maximum value cell in each row in pivot table

[#1]

Hello ,

Does any one have idea regarding change the background color of maximum value cell in each row in pivot table?

Please find attached excel sheet for understand requirement.

Thanks

Dipak

[#2]

     Hai,

Go to the chart in that, go to visual cues their you can set the range and can change the background colour also.

Thanks,

Rathish

[#3]

Thanks for reply.

Yes that i know but my problem is how to find maximum value cell in each row in pivot table

Thanks

[#4]

Hi,

Post ur orginal qvw or qvw with data in inline wizard.

Regards

[#5]

Hi,

Try this in ur load script:

tab1:

LOAD Department,

     Activity,

     Value

FROM table;

tab2:

load Department,max(Value) as MaxVal Resident tab1 Group by Department;

Now go to ur chart expr, expand it, write on the Background color if(sum(Value)=MaxVal,lightred())

Regards