View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
katep katep is offline
external usenet poster
 
Posts: 2
Default PivotTable: possible to display Data Item field as it is?

Yes, very easy - put the column heading of the text field in your list of
fields to be summarised, then add the same field to the data section of the
layout, and summarise as Count. Double click the text field name and click to
No total to streamline the report. The report will include all the values in
the text field and give each one an incidence of 1.
Good luck!
Hope your text is less than 255 characters... (my problem is that my text
fields are mostly longer and Excel truncates them)

"blackpuppy" wrote:

I have two Data Item fields. One is numeric and the other is text. For
the numeric field, I want to use the sum summarization function. But
for the text field, I just want to display it as it is.

Is it possible to display the data item field as it is instead of using
any summarization function?

Thanks!
blackpuppy