Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
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.
Example:
Sales |
30 |
40 |
50 |
10 |
12 |
14 |
16 |
89 |
83 |
Total: 344 |
Here, i would like to Color all the Columns above 40 with Yellow but, the Total must remain the same.
Thanks!!
this could help, =if(RowNo()<>0 and ColumnNo()<>0 and Sum(Quantity) <> Sum(TOTAL Quantity) and Dimensionality() =3 and sum(Quantity) > 50, Yellow())
=if( sum(Sales)<>sum(TOTAL Sales) and sum(Sales) > YOUR_VALUE, rgb(YOUR_COLOR))
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))
hi ,
enable design grid>>
right click on pivot table>>
custom cell format>>
text color
exp--------- if(sales>.. ,red()).
best Regards
Anji
Thanks All for the quick suggestions.
But, somehow i'm not arriving at my goal. Have attached a sample app. Here in the Column Quantity i would like to have all above 50 in Yellow.
You are not expecting this?
Yes, this is what i'm looking to achieve.
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 ??