Filter on a data item

[Manu0521]

 I have product in level5 and subproducts in level 4

my cross tab will have Qty as measure, sales rep as rows and above two columns nested in columns -product, subproduct.


I should show only subproducts whose quantity is less than 50 with respect to my salesreps in my rows.

Sohow will  my filter condition in my subproducts data item be :

I used the below one,but I am getting empty data
Filter( level 4, tuple( currentMember(salesRep Hierarchy),Qty )<50)

Can anyone tell me the issue.

Thanks,
Manu