I've created a pivot table and am trying to condition it with colours so that the sub totals of the row dimensions are a different colour to the breakdown. I have achieved close to what I'm after however as soon as there is only 1 entry within a dimension the colour expression doesn't take effect. In the image the totals are across the top and the black rows however as you can see in the second row the Total is 1 but this matches the sub category colour instead of being black.