Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
I hope this makes sense. Thank you
There was a defect QB-9713 for colors not displaying correctly. It has been fixed in May 2022.