Certified Master Anaplanner

TEXTLIST as aggregation function, but only display unique



Is there a way to get the TEXTLIST function, when used in the aggregation format, to only display unique entries?


I have the formula working in my model, but it is displaying every entry under the parent, rather than unique entries.  I know that the normal TEXTLIST function has a "UNIQUE" option.





Community Boss

Re: TEXTLIST as aggregation function, but only display unique

Hi Matthew,


I'm using the example from Anapedia on Textlist:



There are 3 modules (Source Customers, and Customer Summary are found in the link above)

1. Source Customers, with list of Transaction, line item of Product (format Text), Customers (format List: Customer)


2. Source Customers Cube, with list of Transaction, Customers, and line item of Product Text (format Text)

Formula of Product Text = Source Customers.Product Text[FIRSTNONBLANK: Source Customers.Customers]


3. Customer Summary, with list of Customer, and line item of Textlist Products (format Text)

Formula of Textlist Products = TEXTLIST(Source Customer Cube.Product Text, ",", Transaction, UNIQUE)

Screen Shot 2018-08-02 at 3.40.56 PM.pngThanks,