Only color one Dimension in Pivot Table

[fzalexanderjohn]

Hello,

I habe a pivot table with 3 Levels: Manufaturer, Type and Produkt. I want to a apply a color code just to Type independant how to Pivot Table is sorted.

So, if Type is Dimension 1 it should apply there just as when Type is Demension 3. So I can't use something like

if(Dimensonality()=",'green') because it should also work if the user changes the order of dimensions.

Is this possible?

[timpoismans · Accepted solution]

Hi

Try the following:

If(GetObjectDimension(Dimensionality()-1)='Type',Green())

This should work, even if you re-arrange dimensions.

[fzalexanderjohn]

It works just as I want, thank you!