Re: How to change the background color of the column total?
I haven't understood your problem clearly. I would be good if you upload a qvw with dummy data to explain your scenario in detail.
One thing I can think of as of now is try using Total keyword into your background color formula like this:
=if(Type2 = '1st Time yearly' AND SUM(TOTAL Volume) >= ROUND(S_Svolume_Target/7)*0.28, green(200),.....
The Total will calculate total disregarding all the current dimension. If you want to apply any dimension you can use <> key word to apply over Total. like SUM(TOTAL <Agent> Volume) so now total volume will be calculated as per Agent disregarding other dimensions if you have any.