1. Navigate to: Reports > Saved Searches > All Saved Searches > New
2. Click Transaction
3. Rename the Search Title for easy reference in the future.
4. Under Criteria tab > Standard sub tab > set preferred Filters for the search.
5. Under Results tab > Columns sub tab > set preferred Fields the search should pull up.
6. Then add the field > Formula (Text)
7. Under the Formula column > copy and paste below formula:ltrim(regexp_substr({item},'[^:]*$'))
8. Under the Custom Label column > you may set the label to 'Item Name/Number'
9. Click on Save & Run button.
No comments:
Post a Comment