View Single Post
  #14   Report Post  
Posted to microsoft.public.excel.misc
[email protected] info@wolfganghandwerk.ca is offline
external usenet poster
 
Posts: 1
Default Using text values in Pivot Tables

On Wednesday, 15 May 2019 14:24:31 UTC-3, 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')


Tried this. Seemed like a good idea. But I just get "error" in each box.