Location search and the location hierarchy filter

You can use the Location column to search, sort, and filter the Advanced Price Lookup table within the Location Level you select. The Location column also includes a Location Hierarchy Filter that allows users to group or filter the price data for locations within a location level.

When you select a location hierarchy from the Location Level field, that level is displayed as the column header for the location. The table then displays the item price data for any locations within the Location Level that exists. For example, if you select a Location Level of Metro, the Location column is displayed as Metro. The table then displays any metros with item price data that exists for the specified date range.