Yeah this query returned my desired result...

The result frm Sample App...was 12...

Thnx for the NECJ syntax thingie...

I m new actually to this MDX queries and dont reallt know alot...

yeah steve i tried the same combination by providing values fr year as u mentioned...

But

I dint know abt NECJ can have more than 2 sets...

watss itss syntax...

Can u help...

="WITH MEMBER Measures.[Escrow Advance Average Balance Percent] AS '((["& Parameters!pDimension.Value &"].CURRENTMEMBER, Measures.[Escrow Advance Average Balance])/(["& Parameters!pDimension.Value &"].CURRENTMEMBER.PARENT, Measures.[Escrow Advance Average Balance]))*100', FORMAT_STRING = 'Percent' MEMBER Measures.[Escrow Advance Costs Percent] AS...

Yeah I have Tried Redesigning THE CUBE...

well the cubezz fine coz the data fr other dimensions is displayed correctly and even fr this Particular Dimension...the prob i face is that only...