Control Time Period drop down selections

Akhilesh1011
Contributor

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

 

Akhilesh1011_0-1616137794824.png

 

5 REPLIES 5
ArunManickam
Master Anaplanner/Community Boss

Re: Control Time Period drop down selections

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

 

Thanks

Arun

CommunityMember126793
Regular Contributor

Re: Control Time Period drop down selections

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

 

CommunityMember126793_0-1616148226650.png

Time Range as defined Time Range and Time Scale as Year

CommunityMember126793_1-1616148324173.png

Use the Time Range as Pages (as per convenience)

CommunityMember126793_2-1616148381086.png

CommunityMember126793_3-1616148410665.png

Hope able to shed light as require!

Akhilesh1011
Contributor

Re: Control Time Period drop down selections

@CommunityMember126793
Hi,

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

Akhilesh1011
Contributor

Re: Control Time Period drop down selections

@ArunManickam

Even I am unable to figure out any other way

Thank You Arun

ChrisHeathcote
Community Boss

Re: Control Time Period drop down selections

@Akhilesh1011 

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 

Chris Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA