Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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..
Based on your condition looks like ColumnNo = 0 is not true for some rows.
Check values of ColumnNo in your application.
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())