pivot chart dimensions coloring

[#1]

Hi,

I need to color the different dimensions and the subtotals of each in the respective colors.

I am doing it by setting the background color in the dimensions.I even tried out by enabling the grid view.

But my problem is i need the total row of each dimension to be displayed in one color as shown below:

Product	Location	Seller	Meaure1	Meaure2
a	abc	abc
		adc
		Total
	Total
Total

Currently i am getting like this:

Product	Location	Seller	Meaure1	Meaure2
a	abc	abc
		adc
		Total
	Total
Total

Please help me to format the Pivot chart.

By enabling grid view is there any option to format each individual cell?

Urgent.

Thanks in advance.

[#2]

Double post... please use other one!