MDX Query
I am trying to write a query to generate top 10 cusotmers by channel on rows and current year and prior year sales on columns along with actual scenario. i had written a query where i am able to get the top 10 customers by channel on Rows but not able to get the multiple years on columns.can any one help... the code i written is
WITH SET [Top10] AS 'Generate ({[Channel].Levels(3).Members},
Crossjoin({[Channel].Currentmember},TopCount({[Customer].levels(0).Members},10,[Account].[AC_S40001])))'
select {([Account].[AC_S40001],[Scenario].[SC_Actual])} ---here i need current year and prior year also .. assume current year is FY12 and Prior Year is FY11