I've the pivot table attached, and i need to have different colors for the totals:
.Total commodity specialist
Someone know how i can do it?
Go to Dimension --> In that use + then select Text color and paste that code then try
If(dimensionality() = 4, Red(), Green())
pick(match(Dimensionality(), 2, 3, 4), red(), green(), Yellow())
in text or background color
May I add:
If(RowNo() = 0 or IsNull(Rowno()),
Did you got the solutions? If yes, Please close this Thread or else let me know
Thank you all!!
Retrieving data ...