Adding a Simple Expression to a Pivot Report

The procedures below introduce you to the Expression Editor by showing you how to create a simple expression.  For this, we use the Product Pricing Pivot and add a Total Quantity expression to it.  The basic procedures in this article apply to any expression you create, no matter how complex.  

To add a simple expression to a pivot report:

1. Launch the appropriate pivot report.
   

   

2. As necessary, edit the pivot report.

3. Click Add Expression.
   

   

   The Add Expression dialog appears.

4. Click in the Field Name text field and enter Total Quantity.

5. Click the Data Type dropdown and select Integer.

6. Click the Formula button ( ).
   

   

   
   The Expression Editor dialog appears, with the Fields item pre-selected.

7. Scroll down the list in the bottom-center column and double click Quantity Available.
   [Quantity Available] appears in the text field in the top of the Expression Editor.
    

   

8. Click Operators in the bottom-left column of the Expression Editor.
   The center column refreshes, displaying available operators.

9. Scroll down the list in the bottom-center column and double click the plus sign (+).
   The Expression Editor adds the plus sign to the top text field.
   

   

   Note: The Expression Editor displays the words Syntax Error because the expression is not yet complete.

10. Click Fields in the bottom-left column of the Expression Editor.
    The center column refreshes, displaying available operators.

11. Scroll down the list in the bottom-center column and double-click Quantity On Rent.
    The Expression Editor adds [Quantity on Rent] to the top text field.
     

    

12. Click OK.
    

    

    The Add Expression dialog returns, containing the expression in the Formula text field.

13. Click OK.
    

    

    The Pricing Pivot returns, containing the new field.