Custom Time Mapping
If the client has a custom time dimension file how would you go about mapping this file into Anaplan and then dynamically sum the sales by region by account by product by month?
Find example data set below. I would normally do a custom time mapping to map from the clients time to Anaplan inherent time period but the fact that there are two years in the file is throwing me off. In my mapping I would only be able to choose Jan 19 OR Jan 20 to map to the custom JAN. How would I sum this without hardcoding anything?