To show Price Levels as separate columns on Pricing Saved Searches, perform the following:
1. List > Search > Saved Searches > New > Pricing > Pricing Search
2. On the Criteria tab Set: Price level – is any of pricelevel1, pricelevel2, pricelevel3, (select the price levels needed)
3. On the Results tab set the following;
Item | Summary Type = Group
Formula Numeric | Summary Type = Maximum | Formula = DECODE({pricelevel},’pricelevel1′,{unitprice},”)
Formula Numeric | Summary Type = Maximum | Formula = DECODE({pricelevel},’pricelevel2′,{unitprice},”)
Formula Numeric | Summary Type = Maximum | Formula = DECODE({pricelevel},’pricelevel3′,{unitprice},”)
Note: The part of the formulas within the single quotes (e.g., ‘pricelevel1’) must be replaced with the actual names of price levels (case sensitive) in the account.