Are you looking for the possibility of removing the dimension from the default hierarchy?
If not, can you be more specific about the requirement or if you share sample workbook for your requirement, it would be great.
Actually what i want is row label hierarchy .
A-contains 5 sub row
B-contains 6 sub row
C contains 10 sub row
D contains 15 sub row
i want to expand A it should shows only 5 sub row in expand format.
currently when i am using hirearchy it expands A,B C, D all simultaneously.