ExcelBanter - pivot table

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - pivot table (https://www.excelbanter.com/excel-programming/361373-pivot-table.html)

SaranacLaker

pivot table

When I do a pivot table, I get the number of entries for each description
instead of the amounts. Why?

Die_Another_Day

pivot table

Sounds like the field setting is set to count. Right Click the data and
choose field settings, then choose the mathematic function that you
want.

Die_Another_Day

SaranacLaker wrote:
When I do a pivot table, I get the number of entries for each description
instead of the amounts. Why?

All times are GMT +1. The time now is 02:07 PM.