Saved Search to Show Quantity-Based Item Pricing

1. Navigate to Lists > Search > Saved Searches > New
2. Click Item
3.  Enter the  Title
   
4. Click Criteria
5. Click Standard
6. Filter:
   • Select Pricing Fields…
     1. Pricing Filter: Select Price Level
     2. Price Level: Select any of desired Price Level
        Example: Base Price
     3. Click Set
7. Click Results
8. Click Columns
9. Field:
   
   • Select Name
     • Summary Type: Select Group
   • Select Pricing Fields…
     • Pricing Fields: Select Price Level
     • Summary Type: Select Group
   • Select Formula (Numeric)
     • Summary Type: Select Maximum
     • Formula: Enter Case when {pricing.pricelevel} = ‘Base Price’ and {pricing.quantityrange} = ‘1-19’ then {pricing.unitprice} else null end
     • Custom Label: Enter 1-19 ( example if required)
       In this manner, we can add Formula (Numeric) according to our requirements like range 20 to 49, 50+, etc.

Click Add then Save