Hi I want to Textlist function. I want to get Customers by Product List. But I don't know how to use it. ListLineitemProductCustomerConbinationTextListP1C1☑C1,C2 C2☑C1,C2 C3 P2C1☑C1,C3 C2 C3☑ Do you have any idea?

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

About textlist Formula

CommunityMember125605

Hi I want to Textlist function.

I want to get Customers by Product List.

But I don't know how to use it.

List	Lineitem
Product	Customer	Conbination	TextList
P1	C1	☑	C1,C2
	C2	☑	C1,C2
	C3
P2	C1	☑	C1,C3
	C2
	C3	☑

Do you have any idea?

Accepted answers

All comments

Jitendra.Vishnolia

Hi @CommunityMember125605 ,

Just keep Product list only in applies to of Textlist line item. Then apply the Textlist formula at Customer list

TEXTLIST(Text to concatenate, Separator, List to reference [, Duplicate behavior])
pasting the screenshot for your reference

Hope this helps.

~Jitendra

CommunityMember125605

Hi, @Jitendra.Vishnolia !

I could solve it!

Thank you!

rob_marshall

@CommunityMember125605

Please don't use the function TextList as it has massive performance implications, there is a reason why it has it's own Planual rule (link). Instead, why create a module that is dimensionalized by Product and Customer and use Booleans? Also, please read through this entire post on ways to get around the use of TextList.

https://community.anaplan.com/t5/Anaplan-Platform/Lookup-Sum-and-Textlist-Cheat-Sheet/m-p/53085#M8205

Rob

CommunityMember125605

Hi, @rob_marshall.

I don't want to use text List, not boolean, Because I have to send a order to supplier.

Supplier needs Customer List per Product.

▲Supplier:S1
Order	Product	Amount	Customer
1	P1	100	C1,C2
2	P2	200	C2,C3
3	P3	300

rob_marshall

@CommunityMember125605

Then change the code of the transactional list to be product code_customer code with amount as the line item instead of your order number. With this, you can create two line items: Product and Customer that you can figure out by using the transactional code. Lastly, create a module dimensionalized my Product and Customer.

Now you have the dimensionalized which allows you to do all kinds of fun things.

I could be wrong, but i would doubt your source system stores your customers in one field as you have below.

Rob

rob_marshall

@CommunityMember125605

Or better yet, from your original post, you can create a module dimensionalized by Product and Customer, create a line item that does a sum on the amount. Now you can pivot it by Product and now see the customers as well as the amount without using textlist.

Rob

CommunityMember125605

Hi, @rob_marshall .

I know I can create module by product and customer and see amount of price.

But the point is text concatination.

Quick Links

Can you help?

Unanswered questions

Introducing Anaplan Toolkit: side panel for model details, exports and model lock tracking
Hi everyone 👋 If you build or maintain Anaplan models, you've probably hit the same walls I kept hitting. Some basic questions about a model's structure have no single screen to answer them. You end up clicking through modules and pages one by one, or writing API scripts just to get a list. These were the gaps that…
How to handle an Entity Structure change effective from January 2026 in Anaplan Consolidation & Repo
Hi Everyone, We have a requirement in Anaplan Consolidation & Reporting (Fluence) where the Entity Structure needs to change effective January 2026. The key requirement is that the existing entity structure should continue to be applicable for all reporting and consolidation periods through December 2025, while the new…
Anaplan ⇄ Google Sheets pivot tool — feedback welcome
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…