Color of last/Totals row in a straight table

[swati_rastogi27]

Can anyone help me with setting the color if the mast row in my straight table?

Basically I have a straight table with expressions and the last row is of totals.

I want the row to be highlighted in different color and font.

[luciancotea]

Click on the plus sign of the expression and edit the "Background Color" and "Text Color" using Dimensionality() function:

=if(Dimensionality() = 0, red())

[ThornOfCrowns]

Following on from the above answer, you can change background and font colour, as well as weight and size, but you can't change the font itself.

[swati_rastogi27]

Hi ,

I want to change the background color of only the last row of my straight table and the header row

[luciancotea]

Looks like you want custom coloring of your straight table:

1. Select View -> Design Grid

2. Right-click on the straight table and select "Custom Format Cell"

Enjoy!

[Chanty4u]

chk dis

How to dyanamically change the individual cell color os a Pivot table

Custom Format Cells in Straight Table