Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi
Try the following:
If(GetObjectDimension(Dimensionality()-1)='Type',Green())
This should work, even if you re-arrange dimensions.
Hi
Try the following:
If(GetObjectDimension(Dimensionality()-1)='Type',Green())
This should work, even if you re-arrange dimensions.