Thread: Using text values in Pivot Tables
View Single Post
  #13   Report Post  
Posted to microsoft.public.excel.misc
[email protected] palmer@ring.com is offline
external usenet poster
  
Posts: 1
Default Using text values in Pivot Tables
go to values add value calculated field (at the bottom of the field list) set 'Summarize by' to 'Custom', and use the formula:

=TO_TEXT('field_title')
Reply With QuoteReply With Quote