RESTRICT respects the filtered member and ignores the calculation against the non restricted member where as LOOKUP will show a results against each member including the ones which are not being looked up.
RESULTLOOKUP is even more restrictive as it requires looked member to be in drilled state in the table, else it will not show any results. Also allows only single members as lookup criteria.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.