View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pivot Table doesn't like text Pivot Table doesn't like text is offline
external usenet poster
 
Posts: 1
Default count pivot tables

My raw table has a bunch of text in it. When I go to pivot, it shows the
field to drag and drop, but when I drop it, it shows as "Count". If I try to
change the field settings, it only allows me to change to another calc (SUM,
etc) and none of the options leave it as the raw text. HELP!