Thanks a ton! My scope was considering a lot more than i required. It was hitting half a million rows every time user dropped 'Outlet' dimension onto excel. With below tweak, the results are lightning fast. Fraction of seconds -

SCOPE ([Measures].[YTD Rolling POD Outlet],

FILTER([Outlet].[Customer].[Customer].MEMBERS,[RAD Depletions 9LE Actual All] > 0),

[Date].[Fiscal Month].[Fiscal Month].MEMBERS,

[Item].[Brand Category].[Brand Category].MEMBERS,

[Item].[IPL].[IPL].MEMBERS,

[Item].[IPL Familyand Bottle].[IPL Familyand Bottle].MEMBERS

);

THIS = IIF ([Item].[Price Segment].CurrentMember IS [Item].[Price Segment].&[L],

IIF ([Measures].[YTD RAD] > 0.2395,1, NULL),IIF ([Measures].[YTD RAD] > 0.4835, 1, NULL)

);

END SCOPE;