Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Below Expression Solved the issue.
if(Dimensionality()=0 or SecondaryDimensionality()=0,vColor_RGB_16,vColor_RGB_15))
Thanks a lot Sunny for your help
May be use Dimensionality() instead of ColumnNo() and RowNo()
Thanks Sunny, will try Dimensionality().
Do you think, Dimensionality() will help in applying colors to Total Column (Partial Sums)
I think it should... I don't see a reason why it won't
Dimensionality() or secondaryDimensionality() functions are used to Color the actual data part and not the Total.
This is based on testing or just what you think?
I have tested both the functions, it applies color to entire dimensions and Total column
Would you be able to share a sample where this isn't working?