Cannot return SUM as a calculated measure based on member from query

apologies perhaps obvious solution this, i'm new mdx , olaps , trying find way. have cube has measure dimension derives average measures. incrementally i'm trying solution, using sum, , query below:

with member measures.currentregion as 

sum( { [region].[county].currentmember }
,  [measures].[avgbodyworklabourrate]) 

 select  
 { [measures].[avgbodyworklabourrate], [measures].[avgpaintworklabourrate], measures.currentregion } on 0,
 { nonempty([region].[county].children * [suppliers].[company name].children) } on 1
 from [car cube] 

i'm trying include the [measures].[avgbodyworklabourrate] per supplier company in each row, , include currentregion measure being sum of [measures].[avgbodyworklabourrate] [suppliers].[company name] in [region]. derived member seems return sum of current row, output values equivalent.

ultimately i'm trying implement percent_rank function on region , country dimensions against each measure. appreciate assistance offered, including fast track learning resources on line.

thanks in advance,

sean.

hi newface,

percent_rank used in t-sql, it's different mdx. can use calculated measure calculate percentage,　please refer similar thread: http://social.msdn.microsoft.com/forums/en-us/sqlanalysisservices/thread/793d66d0-0a9e-4520-a42d-3e40346a0116 

more information defining calculated members, please see: http://technet.microsoft.com/en-us/library/ms166568.aspx 

please feel free ask if have question.

thanks,
eileen

---

please remember mark replies answers if , unmark them if provide no help. can beneficial other community members reading thread.

SQL Server  >  SQL Server Analysis Services