Hello
i have some problem with this MDX Statment :

with
SET [kunden] as 'Filter (descendants([Dim_x].[Alle Kunden], , LEAVES),
left([Dim_x],1,1) = "(" ) '
select
{descendants([Dim_Kx].[Alle Kunden], , LEAVES) } on rows,
{([measures].[Standard])} on columns

from z
Result :
Standard
(test1) 44444
(test2) 54567
(test3) 3214
test5 4535
test6 11111
but i want to filter i need only result with () how can i do it please
i need help



many thanks,
Prince

Hi Prince,

I think the problem may be that you need to display the filtered set on
the rows.

i.e.

WITH
SET [Kunden] as '...'
SELECT
{[Kunden]} on Rows,
{[Measures].[Standard]} on Columns
Chris N

prince wrote: