Example - Create an Asymmetrical Crosstab

In this topic, you learn how to create asymmetrical crosstab layouts to view several kinds of data in a single crosstab.

You want answers to these questions:

  • How much are the gross profit and profit margin for two specific order methods?
  • How much is the revenue for all products?
  • How much revenue was generated by two specific markets?

If you need more help, see Inserting Items and Insert Sets of Items in Complex Layouts.

Procedure

  1. Create a new analysis using the Sales and Marketing (cube) package.
  2. Add the following items to the crosstab:
    • Revenue as the default measure
    • 2004, 2005, and 2006 (in Time) in the columns
    • E-mail and Web (in Order Method) in the rows
    • Gross profit and Profit Margin (in Measures) as nested rows
  3. Add Products as a stacked set under Order Method.

    You now want to insert a new set between Order Method and Products.

  4. Select Products as the target location in the crosstab.
  5. In the source tree, press Ctrl+click to select Asia Pacific and Americas (in Retailers).
  6. Right-click the selected names and, from the Insert menu, click Above Selected Set.

    Your analysis will look like this.

    An example of an assymmetrical layout.
Parent topic: IBM Cognos Analysis Studio Examples