Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is there a way to change backgroundcolor or text color to the total row in a pivot table?
Add this in the background colour area of the expressin, it will only format the total row
=if(rowno()=0 or isNull(rowno())
,rgb(255,255,0)
,rgb(255,255,255)
)
you change the colours using different RGB numbers
Hi,
Yes use Background Color option and put there your choice color for background color
Right click -> properties -> click on plus sign -> select backcolor -> go to expression and set your color.
Let me know about this.
Rgds
Anand
No i only want to color the total row. the other rows are in another color.
Hi,
Yes it is possible do with instruction for total
Right click -> properties -> click on plus sign -> select backcolor -> go to expression and set your color.
If you have any sample so provide to me.
Rgds
Anand
No, not what i mean. Look at this picture. See the "Total" row. That's the one i want to put a color tp. Not the expression.
If it is possible of course =).
Press Control+ G. (This will open Grid View)
Then Right click on the total Cell. You will now see Custom Cell Format or somethign like that, you can set colors for just the totals there. YOu may need to repeat a few times for each dimension.
Make sure you have the 'Always Show Design Menu Items' checkbox checked under Settings > User Preferences > Design. Now Right-click on the Total row and select the new menu item 'Custom Format Cell' - alter the colours as you need.
Hope that helps,
Matt - Visual Analytics Ltd
Add this in the background colour area of the expressin, it will only format the total row
=if(rowno()=0 or isNull(rowno())
,rgb(255,255,0)
,rgb(255,255,255)
)
you change the colours using different RGB numbers
this one is promising. But my result shows rows that has no values,'-', too. And the show only because of the background change. I've tried to add som that the expression have to be >0 but the row still shows. Any ideas?
Not sure what you mean the expression only identifies what should be adifferent colour as you can see from the right column below totals have arowno() of 0. If you have null values that you don’t want to display in thepivot on the properties under "Settings for selected dimension"choose suppress when value is null.
your expression should still be the same sum(Revenue) for example and you put the formatting expression in the background area as described in the first reply (Right click -> properties -> click on plus sign -> select backcolor -> go to expression and set your color.)