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

On Wednesday, May 15, 2019 at 7:24:31 PM UTC+2, 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')


Thank you!!!!!!!!!! Clear answer that works quick and great!!!!

--
Â**Firebird Tours*
Â* Â* Â* Â* Â*Award-winning Tours to EuropeÂ*
Â* Â* Â* Â* Â*Â*
www.firebirdtours.com <https://www.firebirdtours.com