Thank you in advance
Here is my mmDX.

SELECT {[Measures].[Actual Revenue], [Measures].[Revenue]} ON COLUMNS ,
NON EMPTY CROSSJOIN( [DistrictIsManaged].members,[Territory].members) ON
ROWS
FROM [Sales vs RepBudget]
WHERE ([Time].[All Time].[2005],[RegionIsManaged].[Region Id].[East])

The problem is that it always return n-rows , for total depending on the
members being return. I need to stop it from returning those total. I try to
disable the ALL, but it really makes your queries.
Thank you
Tomas

Specify which level you need -- instead of [Hierarchy].Members you should
ask for [Level].Members in the crossjoin.

SELECT {[Measures].[Actual Revenue], [Measures].[Revenue]} ON COLUMNS ,
NON EMPTY CROSSJOIN(
[DistrictIsManaged].[DistrictIsManaged].members, -- Note the change
[Territory].[Territory].members --
Note the change
) ON
ROWS
FROM [Sales vs RepBudget]
WHERE ([Time].[All Time].[2005],[RegionIsManaged].[Region Id].[East])

Thanks,
Akshai
--
--
This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"Tomas" <Tomas (AT) discussions (DOT) microsoft.com> wrote