a) Click the Add Pivot Table Field button, then click Plus
on the right side of Field and select Range > City.
b) From the Is a drop-down menu, select Row.
You have indicated that you want the entries in the City column in the sheet named Input in the Excel file referenced as Suppliers
to be rows in your pivot table.
c) Click the Add Pivot Table Field button again to add a second field in the pivot table to count the suppliers.
In the second Pivot Field, click Plus
on the right side of Field and then select Range > Internal Name.
d) From the Is a drop-down menu, select Value, and then, from the Function drop-down menu, select Count.
You have indicated that you want to count the suppliers identified by the column Internal Name in the sheet named Input in
the Excel file referenced as Suppliers.
e) Click the Add Pivot Table Field button again to add a third field in the pivot table to sum up the number of employees.
In the third Pivot Field, click Plus
on the right side of Field and then select Range > Number of Employees.
f) From the Is a drop-down menu, select Value, and then, from the Function drop-down menu, select Sum.
You have indicated that you want to sum up the number of employees in the sheet named Input in the Excel file referenced as
Suppliers.
g) To make the Pivot Fields more easily identifiable, edit the name in the upper bar of each one. For example, use Pivot Field City
for the first, Pivot Field Name
for the second, Pivot Field Employees
for the third.