Pivot Table missing data item
 

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?

Pivot Table missing data item
 

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


acss wrote:
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
Contextures
http://www.contextures.com/tiptech.html