Pivot : Sub Total Color change

[bharani8]

Hi Experts - quick question...

I have a pivot and i need the sub total for each expression to be in different color shade.. May i know how to get that ?

Attached qvw for reference..

[devarasu07]

Hi,

Go to Settings --> User Preferences --> Design and enable the option "Always Show Design menu Items" or short cut (Ctrl+G) to enable grid mode and try to apply custom format cell color

Then right click on the totals row --> Custom Format Cell and change color, border, font etc.

P.S: tried and it's shows all in one color (Total/Sub Total).

[its_anandrjs]

Use Custom cell Formatting for this.

[Anil_Babu_Samineni]

Three Different Colors ??

[bharani8]

I need it for the full row... not one particular Cell..

[bharani8]

Yes...I need it for the full row... not one particular Cell..

[bharani8]

I need it for the full row... not one particular Cell..

[bharani8]

Is this possible ??

[Anil_Babu_Samineni]

Don't think so..

[laxmanqlik]

Hi Bharani,

Try This .. in Measure Expression, hope it will hep you

=if(Even(RowNo(TOTAL)), rgb(219,219,219), rgb(255,255,255))

ColorMix1( rank(total column(1))/noofrows(TOTAL) , rgb(15,97,119), rgb(36,242,197))