To filter data for member combinations, define the access for each member combination using a row in Filter Editor. In filter definitions, two member sets separated by a comma are treated as union of those two member sets (an AND relationship).
For example, assume that user RChinn is assigned the following filter: Access: None. Member specification: Sales, Jan.
The next time user RChinn connects to Sample.Basic, her spreadsheet view of the profit margin for Qtr1 (Figure 146, Results of Filter Blocking Access to Sales, Jan) shows that she has no access to the data value at the intersection of members Sales and Jan, which is marked with #NoAccess. Sales data for January is blocked from view. However, Sales data for other months is available, and non-Sales data for January is available.