Color totals in pivot tables

[tomf122]

I am trying to color code the total columns in my pivot table so they are easier to stand out. 

I was able to color code each dimension  total without issue but having trouble doing so on the measures.

I have the below chart and I basically want the total value to highlighted in each section.

Current logic i have which is working for the first total but not the second as its highlighting individual totals to. 

             If(rowno() =0,rgb(0,220,255),
             If(rowno() =1,rgb(0,0,255)))

Is there a way to declare the total rows so these can be set ? 

[justISO · Accepted solution]

Hi, you can include 'dimensionality' to your formula for better accuracy:

if(Dimensionality()=0 and RowNo()=1, Green(),
if(Dimensionality()=1 and RowNo()=1, LightBlue(),
if(Dimensionality()=2 and RowNo()=0, LightCyan() )))

[tomf122]

Thank you this is working great. 

Just for my own knowledge how does the dimensionality function work. I wouldn't be familiar with it.

[justISO]

Qlik Help could be the first source to look at:

https://help.qlik.com/en-US/sense/August2021/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/InterRe...