How to build a 10 best topcount...?

I'm beginer. I want to build a 10 best brands unit sales in (Foodmart database). where do I start?(From sales cube or shared dimension), pls experts told how to do it?

Use Topcount MDX function.

For example

SELECT TopCount
({[Geography].[Geography].[City].Members
*[Date].[Fiscal].[Fiscal Year].[FY 2003]}
, 5
, [Measures].[Reseller Sales Amount]
) ON 0,
[Product].[Product Categories].Bikes ON 1
FROM [Adventure Works]

See some more

http://msdn2.microsoft.com/en-us/library/ms144792.aspx

http://cwebbbi.spaces.live.com/PersonalSpace.aspx?_c11_blogpart_blogpart=blogview&_c=blogpart&partqs=amonth%3D5%26ayear%3D2005

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.