did you try giving Brand A and Brand B negative values and then use numberformat

0;0;0