different colors in total in pivot table

[#1]

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

[Anil_Babu_Samineni]

Try this

Go to Dimension --> In that use + then select Text color and paste that code then try

If(dimensionality() = 4, Red(), Green())

[maxgro · Accepted solution]

maybe

pick(match(Dimensionality(), 2, 3, 4), red(), green(), Yellow())

in text or background color

[jpenuliar]

May I add:

If(RowNo() = 0 or IsNull(Rowno()),

pick(match(Dimensionality(), 2, 3, 4), red(), green(), Yellow())

)

Regards,

Jonathan P

[Anil_Babu_Samineni]

Did you got the solutions? If yes, Please close this Thread or else let me know

[#6]

Thank you all!!

Silvia