Adding Summary Name and Value Items

You can use the $SUMNAME(n) text variable to insert the name of a summary column heading into a MultiTab report. Summary names typically appear horizontally across the top of a report, from left to right, in the same order as in the final dive window. Starting with the leftmost summary column, ProDiver assigns the column heading item a variable value of $SUMNAME(1). Similarly, the next summary column to the right has a variable value of $SUMNAME(2), and so on for the remaining summary columns in the report.

Use the $SUMVAL(n, B) variable, where n defines the report position of the summary column and B defines at which dimension breaklevel ProDiver totals the summary values. The following example illustrates how ProDiver calculates a total using the $SUMVAL( ) variable in a MultiTab report.

The above example shows that ProDiver, using the $SUMVAL(3,2) variable, would calculate and insert the subtotal value of 1241.23, that is the sum of cost values at the salesperson breaklevel for Paul Agate.

To derive a total value, enter a breaklevel of 0 in the $SUMVAL( ) variable. To calculate a total value for the Cost summary column, for example, you would enter $SUMVAL(3,0).

Complete the following steps to insert the summary column name of Cost and a calculated subtotal and total value for the Cost column in a MultiTab report.

  1. Open the inserting_more_metadata marker created in the Adding Dimension Name and Value Items topic. Alternatively, the steps in this task are applicable to any MultiTab report.

  2. Unlock the report and delete the Dimension Name and Value items or move them to the left side of the report.

  3. Click the Add Item icon and perform the following actions:

    • Click the $SUMNAME( ) variable and type Summary Column: before the variable and 3 between the parentheses.
    • In the Position tab, select Page Right.

  4. Click OK to Closedview the report.

  5. Click Add Item and perform the following actions:

    • Click the $SUMVAL( ) variable and type Cost subtotal for Agate: before the variable name and 3, 2 between the parentheses.
    • In the Position tab, select Page Right and type 15 in the Vertical offset field.

  6. Click OK to Closedview the report.

  7. To add a total value for the Cost column, click Add Item and perform the following actions:

    • Click the $SUMVAL( ) variable and type Cost total: before the variable name and 3, 0 between the parentheses.
    • In the Position tab, select Page Right and type 30 in the Vertical offset field.

  8. Click OK to Closedview the report.