Here is a query that I want to return only the top 6, not the top 6
plus All. How do we suppress the All value in the result set?

SELECT NON EMPTY
HIERARCHIZE(AddCalculatedMembers({DrillDownLevelTo p({[Products].[P-Product
Name]}, 6, , [Measures].[Secured Forecast, lbs])})) DIMENSION
PROPERTIES PARENT_UNIQUE_NAME ON COLUMNS FROM [OurCube] WHERE
([Measures].[Secured Forecast, lbs], [Products].[P-Product
Line].&[Product Line X])

Example answer set (pardon the poor spacing):

All ProdX1 ProdX2 ProdX3 ProdX4 ProdX5 ProdX6
1,519,181 222,01 180,571 495,605 484,573 59,597 57,118

Thank you.

I determined the solution. The TopCount function is the better way to
go.