Hi there, I know this is not the soltution tab but still i would like to share what i did.
I divided my products into 2 sets of collection. one was named as STD and other i named as VAT and then applied custom tax rates to both the collections manually.
Shopify is such a big platform but it has restrictions in many cases where users are helpless.
So are we.