Test that all quantities are stored as figures When the results usually are not what you predicted, the column might incorporate quantities stored as textual content instead of as numbers.Use the field portion of the Field Record to include fields to your PivotTable, by checking the box close to subject names to place those fields within the defaul