@amandeep - have you tried creating a pricing search using these criteria? Item Unit Price Price Level That will give you a list of each item's price level, with the items returned depending on your search criteria. There are also a couple of formula fields you could leverage if applicable: {PriceLevel.name} will id the pricing level name and {PriceLevel.discountpct} will identify its percent. Coupled with other fields, you could do some math for the result you are looking for as well.