So let's say I have multiple departments, teams, sales people, and individual sales records (represented only by ID). Now, In my chart I want to the total sales count but highlight teams with sales folks that have no sales. Attached is a workbook. As you can see, when I add the dimension for the sales person it shows correctly. When I roll it up to the team, it no longer shows it as having someone without a sale. Sorry if it doesn't seem clear what I'm looking for.