I take a spreadsheet and make a pivot talbe using the wizard. When I drag a
field into the data space it says "sum of total units"; but in another sheet,
with essentially the same type of data with the column name of "Annualized",
dragging it to the data space area gives me "count of Annualized". Why is
that? I want the sum in both cases.