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.
This can be handled with LOD calculations. See attached for examples. The include version cannot be aliased but will perform faster than the fixed.
Hope this helps.