Dynamic Color only for Column not Sum

[psk180590]

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!!

[YoussefBelloum]

=if(  sum(Sales)<>sum(TOTAL Sales)  and sum(Sales) > YOUR_VALUE, rgb(YOUR_COLOR))

[stabben23]

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))

[Akina0929]

hi ,

   enable design grid>>

            right click on pivot table>>

                             custom cell format>>

                                                      text color

                    exp--------- if(sales>..  ,red()).

best Regards

   Anji

[psk180590]

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.

[Anil_Babu_Samineni]

You are not expecting this?

[psk180590]

Yes, this is what i'm looking to achieve.

[Anil_Babu_Samineni]

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))

[psk180590]

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.

[Anil_Babu_Samineni]

Do you used Pick(Dim, Field, 'Static1','Static2') as Dimension ??