Colour Total column in QS pivot

[JustynaK]

Hi, 

I cannot colour Total column in QS pivot. I have Years or Months in column (drilldown). I use formula:

if(ColumnNo = 0, rgb())

both colour some rows in total column, but other rows stay white.. How can I change that?

[vchuprina]

Hi,

RGB function should take 3 parameters, so you should change expression to:

if(ColumnNo = 0, rgb(70,130,180))

I selected (70,130,180), but you can select any other color by following the link

https://www.rapidtables.com/web/color/RGB_Color.html

Regards,

Vitalii

[JustynaK]

Oh it was just example, i know rgb has 3 parameters. But the problem must lie somewhere else, why some rows are colured and some not..

[vchuprina]

Based on your condition looks like ColumnNo = 0 is not true for some rows.

Check values of ColumnNo in your application.

[vinieme12]

Use dimensionality() instead of columnno()

You can check the dimensionality() number of the total column by adding it as a measure in your pivot table first

then in the background expression of your measure

if(dimensionality()= 1(or whatever), red())