View Single Post
  #13   Report Post  
Old May 15th 19, 06:24 PM posted to microsoft.public.excel.misc
[email protected] is offline
external usenet poster
First recorded activity by ExcelBanter: May 2019
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: