1. Navigate to Lists> Search> Saved Searches> New
2. Select Transactions
3. On the Criteria select column for:
Type is any of Bill, Bill Payment, Purchase Order
Main Line is yes
4. On Results tab add the following columns:
Mark = show total
Formula (Numeric): CASE WHEN {type}='Bill' THEN 1 end
Formula (Numeric): CASE WHEN {type}='Bill Payment' THEN 1 end
Formula (Numeric): CASE WHEN {type}='Purchase Order' THEN 1 end
Summary type of each formula is Sum.
Summary type of vendor is Group.
No comments:
Post a Comment