1 of 1 people found this helpful
Does using the % of country sales calculation (on the color shelf) work if you change place Brand on the level of detail shelf, then right click on the calculation and select Compute Using-->Brand?
although this doesn't do exactly what I was hoping for, it still might work for my purposes. Basically now each brand is colored by its contribution to the total country sales. Ideally I would have liked to color them based on the aggregate sum (Brand 1 20%, brand 2 15% (aggregate 35%), brand 3 10% (aggregate 45%) but if I choose the right color bands I can get the same effect (see below).