cancel
Showing results for
Did you mean:
Creator III

## Dynamic Color only for Column not Sum

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

1 Solution

Accepted Solutions
Partner - Master

this could help, =if(RowNo()<>0 and ColumnNo()<>0 and Sum(Quantity) <> Sum(TOTAL Quantity) and Dimensionality() =3 and sum(Quantity) > 50, Yellow())

20 Replies
Champion

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

Partner - Master

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

Creator

hi ,

enable design grid>>

right click on pivot table>>

custom cell format>>

text color

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

best Regards

Anji

Creator III
Author

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?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Creator III
Author

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Creator III
Author

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Community Browser