ExcelBanter - Pivot Tables

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Pivot Tables (https://www.excelbanter.com/excel-discussion-misc-queries/75771-pivot-tables.html)

Theresa

Pivot Tables

Hi:

Does anyone know if it is possible to have a text field show in the data
area of a pivot table rather than the count or sum of the text field. If so,
can you please explain.

Thanks,

Theresa

Dave Peterson

Pivot Tables

The data portion is used for numeric summaries--not for text.

Theresa wrote:

Hi:

Does anyone know if it is possible to have a text field show in the data
area of a pivot table rather than the count or sum of the text field. If so,
can you please explain.

Thanks,

Theresa

--

Dave Peterson

All times are GMT +1. The time now is 06:51 PM.