Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I've the pivot table attached, and i need to have different colors for the totals:
.Total buyer
.Total commodity specialist
.Total Cluster
Someone know how i can do it?
Thank you
maybe
pick(match(Dimensionality(), 2, 3, 4), red(), green(), Yellow())
in text or background color
Try this
Go to Dimension --> In that use + then select Text color and paste that code then try
If(dimensionality() = 4, Red(), Green())
maybe
pick(match(Dimensionality(), 2, 3, 4), red(), green(), Yellow())
in text or background color
May I add:
If(RowNo() = 0 or IsNull(Rowno()),
pick(match(Dimensionality(), 2, 3, 4), red(), green(), Yellow())
)
Regards,
Jonathan P
Did you got the solutions? If yes, Please close this Thread or else let me know
Thank you all!!
Silvia