Working With Items in the Crosstab
You can manipulate the way rows and columns appear in
a crosstab for more effective comparison by nesting rows or columns,
swapping rows and columns, limiting the details shown in a set,
and showing and hiding rows or columns.
Analysis is a process in which you explore the relationships between items to help you understand your business. The crosstab helps you discover whether the value of one item is associated with that of another.
Comparisons are key elements of nearly every analysis. The following are different types of comparisons.
| Comparison | Example |
|---|---|
| Simple comparison | Tents versus sleeping bags |
| Multiple comparison | Tents versus golf clubs, tees, and golf balls |
| Multidimensional comparison | Products versus territories, this year to date versus last year to date |
| Mixed grain comparison | Tents versus similar camping products, this year versus last year, and the last quarter versus last year |
| Summaries of measures at different levels | Tents as a share of camping products, as a share of European sales |