Alternate Colors in Pivot tabel

[manojkulkarni]

Hi All,

How do we color the rows in pivot table with alternate rgb and specific color for Total/Sub Total rows ?

[abhijitnalekar · Accepted solution]

Hi @manojkulkarni ,

Please use below set expression in baground color expression property.

if(mod(RowNo(Total),2)=0,green(),red() )

[stevejoyce]

Another approach which i think you are looking for is to use dimensionality().  This will let you have conditions on total/sub-total rows.