ExcelBanter

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

Jim

Pivot table
 
How can I drag the source field to the data area instead of getting sum of or
count of the source field? Thanks

Dave Peterson

Pivottables are used to show numeric summaries.

You can count, sum, average, ..., but you can't show the actual text in that
area.



Jim wrote:

How can I drag the source field to the data area instead of getting sum of or
count of the source field? Thanks


--

Dave Peterson


All times are GMT +1. The time now is 03:09 PM.

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