I have constructed a bit of a query along the lines of the following....
Code:
select {[Measures].[Sales Value], [Measures].[Sales Budget], [Measures].[Sales Variance], 
[Measures].[Budgeted Sales], [Measures].[MS]} ON COLUMNS,
Union({TopPercent(Filter({
Descendants([Sales Person.Sales Person].[All sales person].[IAN SINCLAIR], [Sales Person.Sales Person].[All sales person].Levels(2.0), SELF_AND_AFTER)}, 
([Measures].[Flagged] = 0.0)), 80.0, [Measures].[Sales Value])},
{
Filter({
Descendants([Sales Person.Sales Person].[All sales person].[IAN SINCLAIR], [Sales Person.Sales Person].[All sales person].Levels(2.0), SELF_AND_AFTER)},
([Measures].[Flagged] = 1.0))
})
 ON ROWS
from [toppercent]
when I generate a report its sort of what I'm after but I would like both the SELF and the AFTER on the same row, so i tried to add a crossjoin and in the first join call SELF and in the second call AFTER but then this gives me a right load of rubbish,

how do I construct a query that will allow me to display
Code:
col1   col2    total
and not
Code:
col1  total
col2  total
as both the totals are the same.