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

[sunny_talwar]

May be use Dimensionality() instead of ColumnNo() and RowNo()

[sunny_talwar]

How to use - Dimensionality()

The second dimension... or how to use secondarydimensionality()

[krishnacbe]

Thanks Sunny, will try Dimensionality().

[krishnacbe]

Do you think, Dimensionality() will help in applying colors to Total Column (Partial Sums)

[sunny_talwar]

I think it should... I don't see a reason why it won't

[krishnacbe]

Dimensionality() or secondaryDimensionality() functions are used to Color the actual data part and not the Total.

[sunny_talwar]

This is based on testing or just what you think?

[krishnacbe]

I have tested both the functions, it applies color to entire dimensions and Total column

[sunny_talwar]

Would you be able to share a sample where this isn't working?