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.