How Drilling and Expanding Can Help with Analysis

If you want to visibly compare parent and child values at the same time, then drilling and expanding values can help you analyze the data. For example, suppose you want to see the overall sales revenue for last year, as well as the quarterly sales revenue, for your company. You could use the drill and expand feature in a crosstabulation table to help analyze both the annual and quarterly revenue.