1 Insert a new tab called "Vendor Pivot" to include: Pivot Amount field from the "Base Information" tab by Cost Center Name in the Rows and Vendor in the Columns. Ensure Amount is formatted as currency with two decimals. Make your pivot purple. Add subtotals at the top of each Cost Center Name. 3 Insert a new tab which includes a bar chart to show the number of documents received each day