Thanks so much for your answer. Bummer there's not a way to change the order in a more efficient way. However, your answer does really help, because I did not realize the order of the pills make a difference. Still a Tableau noob, but learning!
Glad it helped. Yes I think the fact that the order controls the display is a by-product of the way a bubble plot is just the circle version of the tile/tree-map. To get your groupings together, I'd recommend a tile/tree-map. In the below I've coloured on both Cat and product. By having both dimensions in the Viz Tableau does group them, and by having them both on colour we get a single colour per Cat, and the intensity difference for each product.
Although bubble charts are visually appealing, tile/tree-maps are visually easier for us humans to compare the sizes (I think it's easier to see in the tree-map viz that Tech and Furniture are the biggest, and around the same size, than on the bubble version). I only use bubble charts if I've got a very un-data (if that's a word!) audiencee, who might not look at the data at all in most other vizes.
Here's one of my all time faves