adding color in pivot for totals and subtotals

[meenakshi_m]

Hello,

Everyone, have been trying to color the total row in the pivot which works fine when the I have one dimension .But when adding 2 more dimensions all the rows get the same color as the total row.

have tried functions like dimensionality()=0 ; rowno()=0 ;columno()=0 but this is not working.

could any one help here 

[Anil_Babu_Samineni]

May be use lsland table with the combination of pick(match()) for expressions and colors. It will give more flexible?

[meenakshi_m]

I have  already used Vizlib Pivot  and need to change it there

[Anil_Babu_Samineni]

Can i test in your app with some scratch data how it looks like and alos provide the expected one?

[meenakshi_m]

hi please find attached.

[Anil_Babu_Samineni]

Please post exact one which you talk about original one? I am not finding the Total at all in chart and explain the result to avoid too much traffic in and out.

[meenakshi_m]

Hi,

There is total row and then sub totals of names under which we have subjects.

so want to color the totals with one and subtotals with another color.

[Anil_Babu_Samineni]

This is what i see?

[meenakshi_m]

Hello

Apologies. Please find the  correct file.

Meenakshi

[Anil_Babu_Samineni]

like this?