you are right Ranuk, thanks for your inputs, but adding "[Reseller].[Business Type].&[Warehouse]" type of condition on member level is easily accomplish but adding <>, <=,>=, AND, OR, CASE stement on that level is not achiving, you can put all this condition at the end of query which will apply to full data set but requirment is to apply conditions on specific member level.