Hi, We are creating a tool in SAS Visual Analytics Version 8.3 which provides user the functionality to change the predicted values for 100 weeks for selected customer (example – “Customer A”) and selected product (example - “Product 123”) (selected via filters). We want to save user inputs at the backend table so that if user selects other customer (example – “Customer B”) and product (example - “Product 124”), old values are saved as well. Example details to develop this functionality in SAS Visual Analytics 8.3 is given below. Column H are parameters wherein users are giving inputs. Using those inputs, we are creating a formula in column K which requires dynamic referencing (basis number of combinations of Hier 3 & Hier 4). We want to replicate formula as shown in column ‘Final Pred’ which gets updated as per selected filter and user inputs. Please suggest a way out or if any other way is possible to develop this functionality. Urgent help will be appreciated. Thanks in advance ! Mahima
... View more