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
got there eventually
number of different methods for doing this
rank
slicer
parent - child - parent(hidden)
just about to try generate