User`s guide

The Formula Workshop appears with the Formula Editor active.
5.
Enter the following formula into the Formula text box:
{Orders_Detail.Quantity} * {Orders_Detail.Unit Price}
6.
Click Save and close to return to the Field Explorer dialog box.
Your formula is listed in the Formula Fields node.
7.
Drag your formula field to the right of the Unit Price field in the Details section of the report.
8.
To subtotal your extension formula, right-click the formula field, point to Insert and choose Summary
from the shortcut menu.
The Insert Summary dialog box appears.
9.
Click Insert Group and create a group on the {orders.ORDER DATE} field.
10.
Choose for each week as the group interval.
Note:
"The section will be printed" drop-down box will not be activated until you choose the Order Date
field.
11.
Click OK to return to the Insert Summary dialog box.
12.
Select the group you just created from the Summary location list and then click OK.
Your data will be sorted by date and grouped in one week intervals.
8.5 Percentages
2012-03-14173
Sorting, Grouping, and Totaling