Control Time Period drop down selections

Akhilesh9025
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

@Akhilesh9025 : 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!

Akhilesh9025
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.

Akhilesh9025
Contributor

Re: Control Time Period drop down selections

@ArunManickam

Even I am unable to figure out any other way

Thank You Arun

ChrisAHeathcote
Community Boss

Re: Control Time Period drop down selections

@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 

Chris
HeathcoteAndHerran.com