Looking for a way to have a data input module of 1Q, 2Q, 3Q, 4Q as one axis and years as the second axis (2020-2025). This grid would be the input module for end-users within Anaplan.
The calculation module uses a monthly time scale. I want the formula to retrieve the value from the input module for the quarter/year which corresponds to the relative month. The equivalent in Excel would be a INDEX(MATCH). I've removed the timescale from the Input file which causes failure in my attempts with LOOKUP/SUM in Anaplan. Community thoughts appreciated.
Example:
Jan-2020, Feb-2020 and Mar-2020 pulls data from 1Q2020
Dec 2021 pulls data from 4Q2021; etc.