2. Select the Search type. (e.g. Transaction).
3. Enter a search name in the SEARCH TITLE field.
4. Under the Criteria tab, enter the preferred filters.
5. Under the Results tab, enter the preferred fields and include the following:
- Formula (Numeric) field > Under the FORMULA column enter rownum.
6. In the SORT BY field select Formula (Numeric) - leaving the DESCENDING checkbox unmarked.
7. Click Preview or Save & Run.
thanks great help.
ReplyDeleteI also select "Group" in "Summary Type" in one of my column and select "Count" in Formula(Numeric) to get this done.