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..
Solved! Go to Solution.
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).
Three Different Colors ??
Don't think so..
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))