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 am trying to bring in sales data to a inventory file for calculating inv. turns.(pls see below for table formats).
So. in inv table i have period (month & year) and I want to bring in the last 12 month sales from the sales file to calculate the turns.(ie. for Jan 2019, I need to sum up from Jan to Dec 2018 sales) Challenge here is same row in sales data will come under multiple periods. I am having both the tables in .xlsx format.
you can use a Multi-Row Formula to add up the last 12 months of the sales table and join the result to the inventory table. I've created a sample workflow and added some sorting to ensure the right order of the sales figures. Hope this is helpful.