I agree with Alvin - you should do some research on MDX and then write your query (assuming you haven't got a problem with your cube).

As a "shortcut", download Olap Pivot Table Extensions from here: http://olappivottableextend.codeplex.com/

Then browse to your cube using excel, create the required layout by dragging/dropping in measures/dimensions and then right click and view the MDX in the extensions menu. You can use this MDX as a base for creating your query.

Please, please learn it properly though. There is a stairway on SQL Server Central you can use.