Pivot Table missing data item

[acss]

I have columns that list invoices ,invoice dates, accounts ,subtotals and
totals. When i try to drag the data item into the DROP DATA ITEMS HERE , it
provides a count and not the amounts that i have in the totals field. What am
i doing wrong?

 

[Debra Dalgleish]

If a field contains text entries or blank cells, the default function is
Count when you add that field the the data area.

To change it to Sum:
Right-click on one of the numbers in the pivot table, and click on Field
Settings
Under Summarize by, click on Sum
Click OK