View Single Post
  #16   Report Post  
Posted to microsoft.public.excel.misc
izzy izzy is offline
external usenet poster
 
Posts: 1
Default Using text values in Pivot Tables

On Wednesday, May 15, 2019 at 10:24:31 AM UTC-7, wrote:
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')


Thanks! This worked for me. Any idea how to make multiple appear if there are two or more text results? Right now it looks like this returns whatever is the top line in the dataset (not the most common), but I would like it to return all distinct.