Insert All the Items of a Level

You can simultaneously insert all the items of a level.

Levels define the way data is grouped in dimensions. For example, a geographical dimension in a source tree might contain levels for country, region, and city. You can click a single city and instantly insert every item that belongs to the city level into the crosstab.

Steps

1. In the source tree, click an item that belongs to the level that you want.

2. From the right-click menu, choose whether to

   • Insert Level(name of item level)
   • Replace with Level(name of item level)

   All the items of the same level appear in the crosstab.

   Tip: You can also drag the level icon  from the Information pane to the location that you want in the work area.