How do I take MAX value of weeks and use it as my monthly value?
To illustrate
Module A in Model #1 has a weekly time dimension
My goal is to take the highest weekly MTA number of a given month and bring it to a new Model that's dimensioned by months and use the MAX weekly value from Model #1 as my new monthly value in Model #2
- MTA's time summary in model #1 is set to Max
- When I brought the data from Model #1 to Model 2
I see that MTA now has an imported value of 18.8 in Jan 22 instead of 4.70.
- How do I get 4.70 to show up under Jan 22 in Model #2?
Best Answer
-
Ok you can do one thing create a monthly module in same model and you can directly refer from weekly module so u will get correct data in monthly module. This module you can import into monthly module in other model. I hope this will help you.
2
Answers
-
Hi @ashasli you can achieve this just by putting summary as Max in weekly module and directly referring that in monthly module.
Thank you
0 -
Thanks @AkhilEmmanual I changed the summary to max in the weekly module and then from the monthly module imported the weekly module. I'm still getting an aggregation of the weeks.
Both of the modules are dimensioned by accounts and SKU#
Please see the attached screenshots.
0 -
Hi
Are you importing data from weekly module to monthly module?. Because i cannot see any formula in monthly module . In monthly module Just refer the line item in weekly module. I hope this will solve your issue.
0 -
@AkhilEmmanual Yup! I'm importing it from weekly to monthly.
0 -
You can directly refer it right ? Why you need to import?
0 -
@AkhilEmmanual I need to import it because they are in two different models.
0 -
Hi, @AkhilEmmanual I created a monthly module but because my time setting is in a 13 4-week periods, I find it difficult to map it to months. I did find a workaround. I was able to import the weekly values to a text field in the other model and it worked (see attachments).
0