novaBBS - microsoft.public.excel.misc - Re: Using text values in Pivot Tables

Re: Using text values in Pivot Tables

<f6bcbf68-b48d-405b-9801-d37e432d52ebn@googlegroups.com>

https://www.novabbs.com/computers/article-flat.php?id=105&group=microsoft.public.excel.misc#105

copy link Newsgroups: microsoft.public.excel.misc

X-Received: by 2002:a37:a7d7:: with SMTP id q206mr20842471qke.439.1620872292732;
Wed, 12 May 2021 19:18:12 -0700 (PDT)
X-Received: by 2002:a25:8312:: with SMTP id s18mr47891125ybk.126.1620872292408;
Wed, 12 May 2021 19:18:12 -0700 (PDT)
Path: i2pn2.org!i2pn.org!aioe.org!news.mixmin.net!proxad.net!feeder1-2.proxad.net!209.85.160.216.MISMATCH!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: microsoft.public.excel.misc
Date: Wed, 12 May 2021 19:18:12 -0700 (PDT)
In-Reply-To: <356db88f-cfc5-44c6-8952-0a75f31425d4@googlegroups.com>
Injection-Info: google-groups.googlegroups.com; posting-host=49.206.42.249; posting-account=2sFk3QoAAADFlfGQIWHM6XjWi-ErNFiK
NNTP-Posting-Host: 49.206.42.249
References: <21DCB7D7-DF60-424B-9779-9D6834417AC3@microsoft.com> <356db88f-cfc5-44c6-8952-0a75f31425d4@googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <f6bcbf68-b48d-405b-9801-d37e432d52ebn@googlegroups.com>
Subject: Re: Using text values in Pivot Tables
From: yrk....@gmail.com (RamaKrishna Y)
Injection-Date: Thu, 13 May 2021 02:18:12 +0000
Content-Type: text/plain; charset="UTF-8"

by: RamaKrishna Y - Thu, 13 May 2021 02:18 UTC

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?

Re: Using text values in Pivot Tables

<6c0b7107-ea67-4f07-be4d-8fc9258e0dc3n@googlegroups.com>

copy mid

https://www.novabbs.com/computers/article-flat.php?id=504&group=microsoft.public.excel.misc#504

copy link Newsgroups: microsoft.public.excel.misc

X-Received: by 2002:a05:6214:f27:b0:474:b51:1a82 with SMTP id iw7-20020a0562140f2700b004740b511a82mr8945270qvb.114.1659235176968;
Sat, 30 Jul 2022 19:39:36 -0700 (PDT)
X-Received: by 2002:a05:620a:139c:b0:6b5:d8ca:19f6 with SMTP id
k28-20020a05620a139c00b006b5d8ca19f6mr7561966qki.764.1659235176799; Sat, 30
Jul 2022 19:39:36 -0700 (PDT)
Path: i2pn2.org!i2pn.org!usenet.blueworldhosting.com!feed1.usenet.blueworldhosting.com!peer02.iad!feed-me.highwinds-media.com!news.highwinds-media.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: microsoft.public.excel.misc
Date: Sat, 30 Jul 2022 19:39:36 -0700 (PDT)
In-Reply-To: <f6bcbf68-b48d-405b-9801-d37e432d52ebn@googlegroups.com>
Injection-Info: google-groups.googlegroups.com; posting-host=158.62.65.113; posting-account=i2Hw-woAAAAShEqkVEFBfTOf36tBPfem
NNTP-Posting-Host: 158.62.65.113
References: <21DCB7D7-DF60-424B-9779-9D6834417AC3@microsoft.com>
<356db88f-cfc5-44c6-8952-0a75f31425d4@googlegroups.com> <f6bcbf68-b48d-405b-9801-d37e432d52ebn@googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <6c0b7107-ea67-4f07-be4d-8fc9258e0dc3n@googlegroups.com>
Subject: Re: Using text values in Pivot Tables
From: jemuel.c...@gmail.com (Jemuel Campogan)
Injection-Date: Sun, 31 Jul 2022 02:39:36 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
X-Received-Bytes: 2376

by: Jemuel Campogan - Sun, 31 Jul 2022 02:39 UTC

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.

Baby On Board.

computers / microsoft.public.excel.misc / Re: Using text values in Pivot Tables

computers / microsoft.public.excel.misc / Re: Using text values in Pivot Tables

Subject	Author
Re: Using text values in Pivot Tables	RamaKrishna Y
Re: Using text values in Pivot Tables	Jemuel Campogan