ColumnNo() Function issue

[krishnacbe]

Hi All,

I am using below expression in a Pivot Table in Expression -> Background color. It is working fine in 11.2.

We recently migrated to 12.10, the color for the total column is apply here and there not to ColumNo()=0

if(RowNo()=0 or  IsNull(RowNo()) or ColumnNo()=0 or IsNull(ColumnNo()),vColor_RGB_16,vColor_RGB_15))

Expectation is to Color Total Columns (Row Wise total & Column Wise Total) with Dark Grey color.

Thanks in Advance.

Regards

Krishnapriya

[krishnacbe]

let me create a mockup data and share it

[krishnacbe · Accepted solution]

Below Expression Solved the issue.

if(Dimensionality()=0 or SecondaryDimensionality()=0,vColor_RGB_16,vColor_RGB_15))

Thanks a lot Sunny for your help

[sunny_talwar]

Awesome!! I told you it is going to work

[krishnacbe]

Yeah, I tried then separately it didn't work. Both in same expression worked perfectly.

[sunny_talwar]

Well you didn't really share which total were you trying to color, so I can only give you a general direction and nothing specific. If you look for very specific help, I would suggest sharing more information then you did

[krishnacbe]

While creating mockup data only I found the Solutions

[sunny_talwar]

That's great, so next time you have an issue, start with creating a mockup and you might as well resolve your issue