Control Module for Creating a View

Hi,

I have to create a view with time dimension and line items as columns and another list as rows.

Not all the line items would be shown for each time and the user has to select manually(ctrl+select each line item and then show) which line items are to be shown for each month.

Is it possible to create a control module that will, say give the user a matrix of time and these line items and they can select which line items they want to see each month(including time summary items e.g. All Period)?

Accepted answers

All comments

ChrisAHeathcote

Hi,

Line Items

This can be achieved by using a Line Item Subset or LISS for short.

Create this LISS and allocate the module containing the line items you would like to filter on.

Create a new module and add the new LISS, users and time as your dimensions. Create a line item called selection and format this as boolean.

On the dashboard or in the module to be filtered select this line item as your filter criteria. The user can then select the required line items from the new control module to limit or filter the line items in the target module.

Time - All Periods

All Periods can not not be selected directly. However, a time filter can be used which references a time properties module where this has been selected using a combination of formulas.

Make sure the summary method is set to 'Formula'

Use this line item to inform you time filter in the target modul.

Hope this helps,

Chris

ArunManickam

Hello @ankit_cheeni ,

It is Possible with Line Item Subsets.

Create a line item subset for your line items,

Create a control module with LISS x Time,

In your module, filter the line items based on your control module,

Here is what you want to see,

Thanks

Arun

ankit_cheeni

@ArunManickam @ChrisAHeathcote Thank you for your solutions. I was thinking on the same lines but the issue with using a line item subset is that it would only take numeric line items and not text(correct me if I am wrong). Some of the line items are text formatted.

Let me know if there is a workaround.

ArunManickam

I dont think there is a workaround, LISS is limited to numeric line items.

Thanks

Arun

ankit_cheeni

Hi Arun, Brain Freeze on my end. I created two conditions, one based on what we discussed(for numeric line items) and another for items that aren't numeric. It worked. Thank you for your help!

Quick Links

Can you help?

Unanswered questions

L2 Import DEM01
Hi all, i'm trying to import the file DEM01 csv but i don't know how to do it How do i select th evalue of DEM01 if the time value is on column? thanks a lot Andrea
ADO File Upload - Semicolon Delimiter
Hi, Based on the regional settings, my default delimiter/separator for CSV files is a Semicolon. In the classic way of uploading a csv file, I was able to select the delimiter. When using ADO, I don't have the option to select a delimiter. Uploading a Semicolon delimited file returns an error, or an upload with only one…
Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…