The approach that you said is fine,but i have more charts same like the one that i have given as example in those charts few charts have more columns MTD,QTD,YTD, AVG MTD, AVG QTD,AVG YTD .....etx. But i can't add that many fields in the DIM Table as its not the ideal solution. so is there any way that we can still use the value list and Hiding the unwanted.
I am not sure why DIM is not the ideal solution? I mean either you create dimension in script or front end, what difference does it really makes? You might be able to replicate the same using ValueList(). I can try it out in the evening.