
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Colour Total column in QS pivot
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?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
If it's possible please mark correct answers as "solutions" (you can mark up to 3 "solutions").

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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..

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Based on your condition looks like ColumnNo = 0 is not true for some rows.
Check values of ColumnNo in your application.
If it's possible please mark correct answers as "solutions" (you can mark up to 3 "solutions").


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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())
If a post helps to resolve your issue, please accept it as a Solution.
