When using multiple shipping profiles, if orders contain products from different profiles or locations, this will result in combined rates at the checkout and the higher rate is charged. Currently, the only available workaround would be to use an app like Multi Carrier Shipping Label App to set up more specific shipping rules as you are asking.
Hi Anindita, just installed the app you’ve suggested. Seems it is for the buying-shipping-label enhancement, which it does not have “more specific shipping rules” setting.