Examine that each one quantities are stored as quantities In case the results usually are not what you envisioned, the column might incorporate quantities stored as textual content as an alternative to as quantities. Use the sector part of the sphere Listing to include fields to your PivotTable,