Max Total % should be in red color(Pivot Table)

[brijesh1991]

Hi All,

As shown in attached image, I have a pivot table, it has two dimentions--ProdType and Month and one expression for % calculation. I had used show partial sum check box for getting total column.

Now I want which ever total is maximum out of all cells of 'Total' column, that particular cell background color should be red color

Your help is valuable to me.. ...

Best Regards,

Brijesh

[#2]

Hi..

As month dimension  u r dragging to right as column name..Hope QV is not having that feature to change colour TOTAL column name..

[Gysbert_Wassenaar · Accepted solution]

Click on the + in front of the expression on the Expressions tab and choose Background Color. Then enter an expression something like

=if(secondarydimension()=0 and rank( ...yourexpression... )=1, lightred() ). Replace ...yourexpression... with the expression that calculates the percentages in your chart. See attached example.

[#4]

1. right clik on the pivot table and go in the properties.

2. now in the expression tab, clik + sign for the expression for the 'Total' column.

3. select the background option

4. in the edit expression window, you can use something like :- if(Total=max(Total), [color code])

hope this might help

[brijesh1991]

Thanks Gysbert Wassenaar. . .

It worked... thanks again

[brijesh1991]

Hey Gysbert Wassenaar,

Your help is amazing and too fast.. I need one more help from you...

Can I show tool tip for each and every productName as and when I hover mouse over there only, not by clicking on productName?

Help text will give overall tooltip, that I don't want

Please share your idea. . .

Best Regards,

Brijesh