Pivot Table missing data item

  • Thread starter Thread starter acss
  • Start date Start date
A

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?
 
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
 
Back
Top