Adding CrossTab Summary and Dimension Items

You can use the $XTAB_ELEMENT and $XTAB_DIMENSION text variables to add the summary and dimension values from a CrossTab as items in a report.

This procedure describes how to create a CrossTab report and then add back the summary and dimension values as items.

Complete the following steps:

  1. Open the model sales_90day.mdl.

  2. On the Console, double-click Company.

  3. To open the CrossTab dialog box, click the CrossTab icon.

  4. Select Ship Month as the Horizontal Dimension and Cases as the Summary.

  5. Click OK to Closedview the dive window.

  6. Click the Report icon to open the Default Report dialog box, accept the defaults, and click OK to Closedview the report.

  7. Click the Add Item icon to open the Edit Item dialog box and perform the following actions:

    • Click the $XTAB_ELEMENT.
    • Type Summary: before the variable name.
    • In the Breaklevel tab, select Page as the Breaklevel and Head as the Location.
    • In the Position tab, select Page Left as the Column and type -20 in the Vertical offset field.

  8. Click OK to Closedview the report.

  9. To display the horizontal dimension, click the Add Item icon and perform the following actions:

    • Click the $XTAB_DIMENSION.
    • Type Horizontal Dimension: before the variable name.
    • In the Breaklevel tab, select Page as the breaklevel and Head as the Location.
    • In the Position tab, select Page Left as the Column and type -5 in the Vertical offset field.

  10. Click OK to Closedview the report.