How can i get the crossover by function

143kishornaidu · 2023-01-16T10:42:41+00:00

There was an error rendering this rich post.

Hi ,

As per the screen shot, in the left grid whenever i select the y the the left grid should show the

same year start month and end month and if i select the y-1 ans week 44 the value then the right side grid should show the 2022 and 44 the week month +1 year

how can i achevie this in a simple way

Accepted answers

All comments

Misbah

@143kishornaidu

Whatever I could understand - it is a typical filter driven grids, meaning you can have "Y" key and "44" key in filters and drive the grids using these filters.

Thanks,

Misbah

Miz Logix

billdowling

Hi,

For this type of question I would have a SYSTEM module that maps Weeks to the Planning Window.

In your example you could then use an IF statement to lookup the values for either Y or Y-1. Below are some screenshots of a simple example:

SYSTEM module for weeks:

INPUT module to set the planning week:

CALCULATION module to work out the planning window:

Hope this helps.

Bill

Quick Links

Can you help?

Unanswered questions

How have you from-scratch built lot-level, geo-based Inventory Consumption?
We’re working on modeling inventory consumption at the lot level, accounting for shelf life considerations, since we need visibility into which lots may not consume—both for risk reporting and E&O analysis. Each item may have customers with different shelf life requirements. For example, item A may need 270 days for some…
How to bring Row data into Columns?
Hi, Can you help me, how can we get row data into columns using Unique ID? Per attached below first snapshot, I want to bring rountingOrder 4, RecipientName, Sent and Completed dates in 1 row as show in sanpshot 2. Do I need to create Hierarchy list and Map?
How to Design Simulation Planning in Anaplan with Multi-Level User Input and Step-by-Step Logging?
Hi Anaplan Community, I'm working on a simulation planning model where users need the flexibility to input pricing adjustments at any level of the product hierarchy, and I’d love your guidance on best practices. 📌 Scenario Overview: We have a 4-level product hierarchy: Brand Category Sub Category SKU (lowest level) The…