Using text values in Pivot Tables
On Wednesday, 15 May 2019 at 22:54:31 UTC+5:30, 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')
It's a great formula. Worked well. Thanks
I tried "JOIN" but failed. Can you show magic with this too?
|