Axis filters are a means of creating complex filters that contain more than one condition in their filter expression, joined by “and” or “or” statements. They are well suited for analysis that takes into account multiple business conditions. Use them when you need to set up filters involving multiple measure items or both measure items and attribute relationships. For example, you have a business need to see all rows of data for products that meet a certain sales goal but you also want to factor in another performance indicator such as a profit margin, rate of return, or average selling price. You use an axis filter with multiple conditions to zero in on the products of interest to you.
You can set up axis filters on the rows or columns axis. For example, use an axis filter to return all rows that fit the criteria of two different measure items -- such as all rows where Sales Units are greater than 1,000 and Profit Margin is less than 20%.