TEXTLIST- multiple dimensions

kristenr

Hi

Could any Anaplan pros please assist with a TEXTLIST aggregation? I am not sure how I would do this over multiple dimensions. It is basically concatenating all the applicable pages numbers into one text based line item for each employee / report version / user.

I have attached the blueprint. The line item I am trying to solve is highlighted in yellow and the values I am trying to concatenate are in the line item called 'Text to Use'.

CAL17 Page Numbers.xls

Thank you in advance!

sobaid

Hi @kristenr ,You can try, and let me know if you've any questions

1.You can create another module with dimension, say Employee dimension and Report version
2. Create a line item, and input the formula
TEXTLIST('CAL17 Page Numbers'.Text to Use, ",", User, ALL)
you can even try below formula if you want unique page numbers and not repeated TEXTLIST('CAL17 Page Numbers'.Text to Use, ",", User, unique)

3.Under Cal17 module under Text List line item, with subsidiary view dimensioned by Employee dimension and Report version, you can fetch using direct reference
4. After you achieved, If you want to increase column size, right click on line item under column settings→Individual column width →input the number say 250 for Text List line item and save the main/Saved view

sobaid

Hey glad it worked out!, would you mind marking the post as answered! Thanks!!

sobaid

Hi @kristenr , if you could picture the scenario or a screenshot of the module view would be helpful

kristenr

Thanks @sobaid - I have hidden the dimensions - they are employee, report version, user

sobaid

I am sorry asking again for details, how do you want the output to be or look like

kristenr

@sobaid - like this:

1,2,3,4,5,6,8,9,10,11,12,13,14. It so the user can copy and paste it into the export pdf select pages field.

kristenr

@sobaid - thank you so much, it worked!!