Formatting Rows separately in Access Pivot Table

A

Al McC

I'm trying to show different back colors for different total rows, but when I
set the totalbackcolor property for one item, the other gets set the same, no
matter what I try. For example:
Me.PivotTable.ActiveView.DataAxis.Totals(1).View.TotalBackColor = 14933984
Me.PivotTable.ActiveView.DataAxis.Totals(0).View.TotalBackColor = 23451
As I step through the code, I see BOTH totals' totalbackcolor attribute
change as each line is executed. Is there a way to allow these to be set
separately?

Thanks for any help you can provide!
 
Top