Below is a simplied version of the query. I try to get the top line with the total for all, but it's including the area manager.
with
member
[Measures].[MOverallExp]
as ([Version].[Version].&[1], [Metric].[Parent Metric].[Overall Experience], [Measures].[Rating 5 Pct], [Timeframe].[Timeframe].[Rolling
3 Periods]) set
[Top]
as [Restaurant].[Restaurant].[All Restaurants]
TopPercent(Exists([Restaurant].[Restaurant].[Restaurant].Members),
10, [Measures].[MOverallExp])
+
select
[Measures].[MOverallExp]
on
COLUMNS,
non
empty [Top] * { [Restaurant].[Area Manager].[Area Manager] }
DIMENSION
PROPERTIES
MEMBER_CAPTION
on
ROWS
from
PGE
where
( [Time].[Time].[Fiscal Period].&[2012]&[2], [Restaurant].[Restaurant By Brand].[Brand].&[SWI])
CELL
PROPERTIES
VALUE,
BACK_COLOR,
FORE_COLOR,
FORMATTED_VALUE,
FORMAT_STRING,
FONT_NAME,
FONT_SIZE,
FONT_FLAGS;