I would like to have Color in my Pivot Table when the number is greater then a particular value. But, the Color of the column Total must remain default.
Here, i would like to Color all the Columns above 40 with Yellow but, the Total must remain the same.
This is could also be implemented in Background color in Your Expression.
Dimensionality()=1 if you have 1 Dimension, Dimensionality()=2 if you have 2 aso...
=if(Dimensionality()=1 and sum(Cost) > 40,rgb(255,255,0))
You are not expecting this?
Then both of the above solution should work for BG color of expansion from expression
=if(Sum(Quantity)<>Sum(TOTAL Quantity) and Sum(Quantity) > 50, Yellow())
=if(Dimensionality()=1 and Sum(Quantity) > 50,rgb(255,255,0))
The problem is i'm also getting the color on the Total column
(I have color code for >20 here)
As in the below Screen shot(i masked out my Product Name) and also in the Row Total it is turning out Yellow.
I don't want color in the Total column.
Do you used Pick(Dim, Field, 'Static1','Static2') as Dimension ??