Time Dimensioned Data to No Time Dimension (Last Non Blank)
I am trying to take data that is dimensioned by two lists and time to a module that is only dimensioned by one of those lists and no time.
Dimensions: List 1, List 2, Time
Line Item: Formatted as a month and calculates Start Date and has it show up for the month that it is in (ex: Feb 20 is start date so in Jan 20 the line item will show blank but in Feb 20 the line item will show Feb 20 and in March 20 it will be blank); formatted to be a last non blank summary
Dimensions: List 1
Line Item: Is formatted as a month and SHOULD bring in the month that is not blank / is populating in Module 1 but I am not able to get this to populate.
QUESTION: How do I get the line item in Module 2 to populate with the month that is populating in Module 1?
Please let me know if you have any suggestions/ thoughts or if I provide any additional details. Thank you!