1. Forum
  2. Usenet
  3. MICROSOFT.PUBLIC.EXCEL.MI

  • Using text values in Pivot Tables

    From martin.bannister91@gmail.com@21:1/5 to pal...@ring.com on Thu Jul 16 08:40:45 2020
    On Wednesday, 15 May 2019 18:24:31 UTC+1, pal...@ring.com 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')

    Brilliant! Thank you!

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From c19kollam@gmail.com@21:1/5 to pal...@ring.com on Sun Aug 2 19:34:47 2020
    On Wednesday, May 15, 2019 at 10:54:31 PM UTC+5:30, pal...@ring.com 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.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Tahsin Dane@21:1/5 to c19k...@gmail.com on Wed Feb 10 13:53:44 2021
    On Monday, August 3, 2020 at 4:34:49 AM UTC+2, c19k...@gmail.com wrote:
    On Wednesday, May 15, 2019 at 10:54:31 PM UTC+5:30, pal...@ring.com 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.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From RamaKrishna Y@21:1/5 to pal...@ring.com on Wed May 12 19:18:12 2021
    On Wednesday, 15 May 2019 at 22:54:31 UTC+5:30, pal...@ring.com 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?

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Jemuel Campogan@21:1/5 to RamaKrishna Y on Sat Jul 30 19:39:36 2022
    On Thursday, May 13, 2021 at 10:18:14 AM UTC+8, RamaKrishna Y wrote:
    On Wednesday, 15 May 2019 at 22:54:31 UTC+5:30, pal...@ring.com 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?

    Hi everyone. I know this thread has been more than a decade old but I'll just post this in addition to what everyone has already shared just in case anyone else stumbles upon this thread.

    I use this formula to concatenate text values and join them with a delimiter (e.g., comma and space).

    =TO_TEXT(JOIN(", ", {'Field Name'}))

    Adding the curly braces (i.e., { and }) to the 'Field Name' will pull all the values from the result of the Pivot Table's query and create an array of values from it. From there, the JOIN formula can work its magic. Just replace the delimiter with
    whatever you want.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Xavier Vanegas@21:1/5 to in...@wolfganghandwerk.ca on Tue Aug 9 08:49:19 2022
    On Sunday, May 19, 2019 at 1:32:05 PM UTC-4, in...@wolfganghandwerk.ca wrote:
    On Wednesday, 15 May 2019 14:24:31 UTC-3, pal...@ring.com 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.
    this one worked for me! Thank you so much!

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)