Static column with Date changing column
Hi there. I am not a data techy and am more DIY. I am struggling with what is probably a very easy thing to do in Analytics. I want to be able to take our Stock on Hand at the date I run a report and compare it with a sales period from the past. It's a rudimentary way to forecast for production needs or problems. Setting reorder levels don't really help our production schedule/business needs because of seasonality and production timing. I get SOH and filters, but when I change dates, the available SOH number changes. I am guessing because the system available ones from Zoho are based upon data in period too. If someone can help guide me to know what I am missing or how I can achieve what I am looking to get, that would be appreciated. Thanks!