In the previous recipe, we dealt with highlighting cells based on their results in comparison with sibling members, which can be visualized in a horizontal direction. In this recipe, we will take a look at how to do the same but in a vertical direction, using the descendants of members in the report.
Bubble-up exceptions are a nice way of visualizing information about the descendants of a member without making reports too big. By coding the information about the result of descendants, we can have compact reports on a higher level, while still having some kind of information about what's going on below.
The information we are going to bubble-up will be presented by color-coding the cells.
Start SQL Server ...