Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need help to change the background color of the column/sub total.
I was comparing agent's performance against the monthly target per agent. The background color is green if its above the target and black otherwise.
But the background color of column/sub total also changed. It should only be changed if TOTAL values >= Team target (NOT if Total Values >= AM target)
My table looks like this.
Thanks in advance!
MENU-->SETTING-->DESIGN-->CHECK ON ALWAYS SHOW DESIGN MENU
THEN
Right click on the ANY DATA OF CHART(OBJECT) and select Custom Format Cell from thepopup- menu.
If you don't have this option, you can enable it via Settings|User Preferences, Tab Design, Always Show Design Menu Items
It didnt work.
I use the the attached formula to change the attribute.
But I dont want the background for totals
Hi,
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.
Hope this help.
Regards,
Anosh Nathaniel