Using text values in Pivot Tables
On Monday, August 3, 2020 at 4:34:49 AM UTC+2, wrote:
On Wednesday, May 15, 2019 at 10:54:31 PM 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')
Great... your solution saved a lot of time for me.
Hey all, adding on top of what's already shared here, I figured out how to combine all values. 🎉
=TO_TEXT(CONCATENATE(Feedback))
I also needed to add new lines to all entries so that they make more sense.
|