ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot Table Question (https://www.excelbanter.com/excel-discussion-misc-queries/55569-pivot-table-question.html)

Ray S.

Pivot Table Question
 
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.

Ray S.

Pivot Table Question
 
Never mind guys. Sorry. I found the answer to my question.


All times are GMT +1. The time now is 02:25 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com