Control Time Period drop down selections

Hi Anaplanner,

I have a scenario where the time period(year) should be selected from the dropdown for a line item. The model calendar holds 9 years and a time range holds 3 years.

I require the dropdown to show only the years included in the time range.

Is there any way to setup a dependent dropdown and not by creating custom list?

In the below image, I have 9 years displayed in the drop down but I require "FY20"," FY21" and "FY22" only

Accepted answers

All comments

ArunManickam

I think the only way is to create a fake year list and map it.

Thanks

Arun

CommunityMember126793

@Akhilesh9025 : If you only want TimeRange to be shown in list then Select the Time as "Time Range":

Time Range as defined Time Range and Time Scale as Year

Use the Time Range as Pages (as per convenience)

Hope able to shed light as require!

Akhilesh9025

@CommunityMember126793
Hi,

The scenario is about limiting the dropdown items to select for a line item with Time Period(year) format.

Akhilesh9025

@ArunManickam

Even I am unable to figure out any other way

Thank You Arun

ChrisAHeathcote

@Akhilesh9025

Create a fake time list for years and use subsets for limiting what is seen for each use.

Map this into time as a list item property.

This will need to be updated periodically as the model is rolled forward into new years.

Good luck,

Chris

Quick Links

Can you help?

Unanswered questions

import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…