How to use only desired values of a field as dimension in charts ?

[#1]

I am suppose to create a chart where in i have Division as a dimension . For e.g ( this division has values FOOTWEAR , APPARELS,

ACCESSORIES , HARDWARE ) , Now in my scenario instead of calculating the expressions w.r.t all 4 fields , i need to calculate it on

only 3 fields  :

1) Footwear

2) Apparels

3) Accessories & Hardware (Combined )

Can somebody please suggest me how can i do that since in normal scenario i can simply take Division as Dimension but that will

calculate expression w.r.t all 4 values instead of 3 which i want ....

Thanks in advance !!