PowerPivot DataModel nested dimensions

Hi all,

I'm self teaching myself PowerPivot and DAX (with a fair bit of experience in SQL and advanced Excel formulae)

I have build a simple data model and would like to build a pivot table which behaves the same as a normal Excel pivot - That is to say that I can nest related dimension fields in the pivot rows and when expanding it will only show relevant rows.

At the moment, whatever I nest in the Pivot rows shows the full population of records, not just those relevant to it's parent.

Is this possible? Have I missed something?

Many thanks

R