Preferred Vs Non-Preferred Merchant Pivot Grid

Use the Preferred Vs Non-Preferred Merchant pivot grid to view preferred merchant spending.

This example illustrates the fields and controls on the Preferred Vs Non-Preferred Merchant pivot grid.

Preferred Vs Non-Preferred Merchant pivot grid

This query selects amount and expense type data from expense reports that do not have a Pending, Denied, or Closed status, for preferred merchants within the business unit. All amounts are displayed in the currency of the business unit. Use the Filter section to reduce the data displayed by expense type and preferred merchant.

Field or Control Description

Business Unit

Displays the business unit. To change the value of this field, click the Options Menu icon and select Prompts.