...
- One Row - This will list the table as a customer table and you will not be able to create aggregates with this option selected.
- More Than One Row - This will list the table as a transactional table and you will have the option of creating aggregates.
- I'm not sure, figure it out for me - based upon the selected table, the system will automatically choose what table type it believes to be the best option and it will set the table type for you.
- Cancel - It will exit out of the Table Type prompt and there will be no changes.
- Drag the New Aggregate item and drop it into the Criteria tree, where the Aggregate Function window will open.
- In the Aggregate section, you will select what Function and Object to be used.
In the Group section, you will have three options to choose from:- All Orders - The aggregate is put into an unfiltered, default group.
- New - Allows you to customize the Group name and add a Group filter.
- Select - Allows you to choose a group that already exists to place the aggregate in from the drop-down list.
- If you select New, click the Add Filter button (
). - In the New Group Filter section, drag and drop the field(s) into the criteria panel.
- Choose the appropriate condition(s) and value(s).
- Enter in your name for the filter and press OK to go back to the Aggregate Function window.
- In the Name section, you can either enter a name for the new aggregate or use the default name given.
- Click OK to save changes.
...