Okay, so let's see if this works. Start by turning your table calculation into a few separate calculated fields:
Order Count Running Sum
Order Count Running Sum Rank
RANK([Order Count Running Sum])
Order Count Running Sum Rank will then replace your existing pill/table calc.
Then create one more calculated field:
[Order Count Running Sum Rank]-LOOKUP([Order Count Running Sum Rank],-1)
Drag Difference up to the color card and set it to calculate as follows:
Be sure to set it to Restart at every Sub-Category or else it will base the color of January on the difference between January and the previous sub-category's December.
You'll now have something like this:
Is that what you're looking for? If so, see attached workbook.
Following up on this one. Let us know how we can help further.
Sorry for the delay in getting back to you, Ken. This is great. My only problem is that I don't seem to be able to choose the 'sub-category' equivalent as the 'restarting every' option in my actual workbook. I'll keep playing around with it, but if you have any ideas, grateful to hear them.
Figured it out - my Running Sum Rank was being calculated across instead of down. I changed it to calculate by 'Subcategory' and that did the trick. Thanks again for all your help!