This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
i would like to create 3 new latest month fields(Current Month,Previous Month,Previous Month-1),using 3 new fields i would like to get pull latest 3 months data to the workflow. please help me someone to achieve this. i have added the sample file
Note, this wouldn't get your previous three months sales, because you're dropping off those records in the join. You would need to join back to the original data at some point based on the other dates. That's why MonthValue, Month-1Value, etc are error.
2. The total spent in each store in each of the 3 months?
3. The total for each customer in each of the 3 months? This last one will not give you much information since if we look at unique First Name, Last Name and Address, we only have 3 repeat customers. and 2,666 unique ones
Sorry I got it what your referring, I have created duplicates on Customer ID, same record now repeating from all months, Now I would planning to create the 3 new columns to pull the 3 latest months data. I have attached the updated sample file please check