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.
Hello! I am trying to get the price of an item before it was put on markdown, but I have to filter the data to a certain date to see what price type it is first. While the filtered date is set, the dates the retail type happens can vary greatly. What do I need to put here to get the previous price?
In order to access values on other rows, you need to use the Multirow tool.
You also need to make sure that your data is sorted in the proper order, in this case by Item, Store and Start. Once sorted, the multirow tool can access the value from the previous row giving an output that looks like this
With this method, you can set the WasPrice for every item that had rollback without filtering on the dates