Data from With time to No time Dimension
How can i pull a data from a module with time dimension to target module with no time dimension using a finditem mapping made in the source data?
To illustrate, my total sales of 1,000,000 was divided into 3 months(using a time dimension) using a condition that turns the distribution this way:
Jan 20 - 3,000,0000
Feb 20 - 2,000,000
Mar 20 - 5,000,000
I will need to draw this amount using a new list(Month 1, Month 2, Month 3) in replacement of the time dimension(all other dimensions retained) to arrive to this:
Month 1 - 3,000,000
Month 2 - 2,000,000
Month 3 - 5,000,000
Appreciate if you can assist me on this.