Hello,
I have tow queries in one designstudio report,
one query has dimension "Fiscal year / period", content like "K42012009",
another query has dimension "Calendar year/month", content like "201209".
I want create one month dropdown link to "Calendar year/month",
but I also want the dropdown can control "Fiscal year / period".
Does DesignStudio script provid string function (or built in function)
let me can transform string from "201209" to "K42012009" ?
BR,
James