In the following example, a table visual is filtered based on the top five products for the Internet Net Sales (PYTD) measure:
For this visual, the prior year-to-date (PYTD) measure used for the filter condition is not one of the three measures displayed. Nonetheless, the following Top N condition filters out all products, including the top-selling product for the current year, that weren't one of the top five products in the prior year:
With a Top N filter defined ...