Parents of filtered children

[cogusergirl]

Hi

I am sure I am doing somthing silly

hierarchy

brand group
     brand
           product


I have a query item that selects top 20 products (no matter what brand group) I wish to display which Brand group they fall into, however every time i drag in Brand group before my top 20 products it displays all brand groups

How do I filter the parent of product to only show those brand groups where a top 20 product has been found

I have tried parent but top20 is a member set and it wants a member

thanks in advance for any help

[cogusergirl]

got there eventually

number of different methods for doing this

rank

slicer

parent - child - parent(hidden)

just about to try generate