You could achieve this if you used an expression in your dataset and returned the appropriate columns based on the parameter. There's more info on an implimentation of that sort of thing here: http://social.msdn.microsoft.com/forums/sqlserver/en-US/d38929c5-7261-452a-8ea3-839695189f24/mdx-dynamic-column