Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivottable Calc. Avg. field based upon monthly data | Excel Discussion (Misc queries) | |||
PivotTable - summing more than one data field | Excel Discussion (Misc queries) | |||
function to reference all of pivottable data field array | Excel Worksheet Functions | |||
Pivottable data field | Excel Discussion (Misc queries) | |||
PivotTable controlled by more than one page field item | Excel Programming |