Examples of Sorts and Filters on Totals

This view displays year to date (YTD) sales data by Sales Director and UPC Global Number. A filter has been applied to the total column for the current year YTD sales. The result is a view where the only detail sales data on display for each Sales Director is that of Products that make up the top 20 percent of total YTD sales.

In this example, quarterly sales data is displayed by Distribution Center Warehouse and Customer Ship-To. A filter has been applied to the total column for the current year, current quarter sales. The result is a view where the detail data on display is Customer Ship-To’s with total sales greater than $2,000,000. Also, a sort was applied to the same total column to organize the Customer Ship-To’s in descending order.