Hi, I need drilldown only one row, it's is possible with MDX Query..

e.g.

SELECT
{ [Measures].[Total Product Cost] , [Measures].[Tax Amt] } ON COLUMNS ,


{ [Dim Product].[Spanish Product Category Name].MEMBERS}
*
{iif( [Dim Product].[Spanish Product Category Name].currentmember.Name
= "Prenda",
[Dim Product].[Spanish Product Subcategory Name].members
,
[Dim Product].[Spanish Product Subcategory Name].[All]
)} ON ROWS

FROM [Adventure Works DW C1]

I need a only Member "Prenda" is drilldrow to Spanish Product
Subcategory Name members.

this result :


Total Product Cost Tax Amt
All All 17277793.5757 2348694.2301
Accesorio All 262085.391899997 56060.7968000007
Bicicleta All 16812348.1501 2265451.62449999
Componen All (null) (null)
Prenda All 203360.033699999 27181.8087999998
Unknown All (null) (null)



And I need this:

Total Product Cost Tax Amt

All All 17277793.5757 2348694.2301
Accesorio All 262085.391899997 56060.7968000007
Bicicleta All 16812348.1501 2265451.62449999
Componen All (null) (null)
Prenda All 203360.033699999 27181.8087999998
Prenda Calcetine 1909.7864 408.5056
Prenda Camiseta 13346.9379999999 2854.96000000001
Prenda Culote co (null) (null)
Prenda Gorra 15159.8370000003 1575.048
Prenda Guantes 13097.7989999997 2801.65599999993
Prenda Jersey 133172.0236 13836.0543999999
Prenda Mallas (null) (null)
Prenda Pantalon 26673.6496999994 5705.58479999996
Unknown All (null) (null)

I have the solution using Filter(xxxxx)

thank