View Single Post
  #12   Report Post  
Old September 29th 17, 12:12 PM posted to microsoft.public.excel.misc
Rainonthesun Rainonthesun is offline
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2017
Posts: 1
Default Using text values in Pivot Tables

Seems like this has still not been implemented by Google. I am having to add a vlookup field as a separate field next to the pivot. I was hoping that max() would work on text fields as well.


On Tuesday, September 22, 2009 at 6:42:02 PM UTC+1, Eric wrote:
I am creating a simple pivot table with one field of values, numbers to be
summed, and a second field, occasional two letter alpha codes which are purely
descriptive and refer to the number in the same column, "row".
In the source spreadsheet, I have formatted the column which contains these
codes as "Text". Text is supposed to remain unchanged; however when that
column of data is entered into the pivot table as a value, it is handled as
though it were numeric data, and these two letter codes do not appear.
Because the software apparently recognizes the values as non-numeric it
assigns a "Count" descriptor by default, but this only converts each instance
of a the text values to "1", thus losing their original identity.
All the possible definers of the field are numeric operators like "Count" and
"Sum", which do not apply to an alpha code, which is just supposed to be
represented literally. Further I see no way to manipulate this data field to
be recognized as text in the pivot table itself.
How do I get the pivot table to just take this alpha data as is?
Thanks,
Eric