@joshuastockwell Hi This is the same principle as a post a few weeks ago https://community.anaplan.com/t5/Best-Practices/How-to-reduce-the-dropdown-list-of-a-column/m-p/40944#M4247 But let's go through the steps 1. You should already have a time settings module; if not create one now!! Within this, link to the Currentperiodstart() to have various booleans for history, current, future periods etc. 2. Create a single item list (this will be the driver list). 3. Create a line item (formatted as above) in the Time Settings module and apply the appropriate logic 4. You will need to create a fake time scale that matches the normal timescale Top Tip - to make it easier to match, use the same format as the timescale - e.g in my example mmm yy 5. Create a mapping module dimensioned by your fake time scale from 4., and map in the real timescale and then pull in the "future?" list item from the time settings Top Tip - FINDITEM(TIME, xxx) is the way to match to a timescale The line item formula for Future? is Monthly Time Settings.Future?[LOOKUP: Time] 6. Create a list property in the "Future?" list and point it to the line item above 7. In your target module, you will need to create a line item that holds just Future?.Future? (make sure the dimensionality is set to none) 8. Now you add you drop down list line item and use the line item above to apply the dependency. You will of course have to match this chosen field back to the real timescale, but you already have the mapping module from 5 to use for that I hope that helps David
... View more