Tag Info

New answers tagged


Try WITH Member [Age Band] Instead of WITH set[Age Band] Since you are doing a calculation based on the [Measures].[Age] Try the following and see if you can work with WITH MEMBER with member [Age Band] AS IIF([Measures].[Age]<26,"0-26",IIF([Measures].[Age]<51,"26-51","Over 50")) SELECT {[Age Band] } DIMENSION PROPERTIES ...

Top 50 recent answers are included