Nesting Groups and Calculation Items

As you work with groups and calculated items, you might want to "nest" them; that is, create a group within a group, for example. The following list provides various scenarios for nesting groups and calculated items:

  • Groups can be nested; that is, they can include other groups. Nested groups are "flattened." For example, suppose that the my_favorite_countries group includes the my_favorite_cities group. When you display and expand the my_favorite_ countries group in a table, you do not see the my_favorite_cities group. Instead, you see the member values of the my_favorite_cities group.

  • Calculated items can be nested; that is, they can include other calculated items.

  • Groups cannot contain calculated items nor can calculated items contain groups.

  • When you work with selection steps:
    • You can save selection steps that include groups or calculated items as either a series of steps whose results are generated at runtime or as results that are static and are redisplayed each time.

    • You can apply a group that is a saved selection of steps, using the Catalog pane. If you do so when the saved selection contains a step for a calculated item, then you can only add the members of the group. You cannot add the group itself.