Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

After running the report, the imported data looks like this:

Image Modified

Creating a PivotTable

...

Now look at the sheet containing your PivotTable. You should find the EmployeeID numbers across the top and all the vendor names along the left column. Each cell will contain the sum for each vendor/employee combination.

Image Removed

Image Added
 Select on the thumbnail to expand the image

Click on the down arrow next to the Vendor Name label. Clear Show All and just select a few vendors.

...