Line Item Subset for Text Formatted line item

Is there a workaround for selecting a non-number line item in a Line item Subset?

I've created a filter for increasing and decreasing the number of lines shown in a dashboard table using David Smith's outline in this post: https://community.anaplan.com/t5/Anaplan-Discussions/Filter-Line-Item-in-Module-view-based-on-another-Line-Item/m-p/31059/highlight/true#M418.

The problem I'm running into is only being able to select Number formatted lines for the dashboard table. My users have a comment field that I need to retain in the view.

Tags

Modeling

Calculation Functions

Accepted answers

Sorry, but a line item subset can only use the number format, so no booleans, texts, or dates.

Rob

The only option is to have the comments field displayed separately on the grid, synchronised with the page selector

You can do this by publishing the line item directly or create a 'comments module' dimensioned by the relevant list.

I normally position these under the grid so that you can expand it to give a decent amount of space for comments.

Hope this helps

David

All comments

Sorry, but a line item subset can only use the number format, so no booleans, texts, or dates.

Rob

The only option is to have the comments field displayed separately on the grid, synchronised with the page selector

You can do this by publishing the line item directly or create a 'comments module' dimensioned by the relevant list.

I normally position these under the grid so that you can expand it to give a decent amount of space for comments.

Hope this helps

David

Quick Links

Can you help?

Unanswered questions

Not Able to Join the Level 1 Model Building Course
Hey Everyone, I was trying to learn about the Level 1 Model Building Course, when i log in to my system and click on "Start the course" option its showing training unavailable, Can anyone please help me with this @Dikshant and all?
Generating Failure Dump - even though no warnings/error in Actions
I've few actions in our Supply model which when run takes some time on the "generating failure dump" step at the end of the action even though the import is a full success without warning or errors. This is just a few seconds when run for a single action, however we have a process with 120 actions, and most of these…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…