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