Is there a way where I can pivot multiple columns from my table to pivot into 3 currencies (LAK, THB, USD). The columns I want to pivot are premium, discountedPremium, registryFee, vat, etc. Please see image below.
I want the result to be like in the image below:
thank you for your guidance.