Change the Font color or highlight the total in pivot table

[#1]

i Have used the below code to get both average and total , when we check subtotal box in pivot table. But i need to change the color of average and total to differentiate it, how can i do this

=if( secondarydimensionality()=0,

sum([Amount To Pay LC]) & chr(10) &

avg(aggr(sum([Amount To Pay LC]), [Vendor Name], Month)),

sum([Amount To Pay LC])

)

[jonathandienst]

Hi

Cant see your image, but I think what you need is as follows:

• On the expressions tab, for that expression, click the + icon
• Select Text Color
• In the Definition box, enter your colour expression; something like:

          =If(SecondaryDimensionality() = 0, LightRed(), LightGreen())

(change the colour as required. You can also use the RGB() or ARGB() functions to set colours by rgb values)

Hope that helps

Jonathan

[#3]

Hi Jonathan,

When i apply the code , it gives the attached output, Both total and average are in red color in the last colum. I want it to be

different. Or i want to add a text showing 1st line Total=

2nd line Avg=   So that we can come to know which is total and avg