Forum Discussion

tylesftw's avatar
tylesftw
Icon for Helper II rankHelper II
6 years ago

Cumulative Sales - Getting the Sales Line to Stop

Hi All,   I've been given a dataset that has both Sales & Forecast in one dataset. This means that the below code does not work as it extends out the sales line to match the FY2020 months. Without ...
Need Help
Tips and Tricks
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

tylesftw ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

tylesftw's avatar
tylesftw
Icon for Helper II rankHelper II
6 years ago

Have added the visualisation.. essentially the data looks like

 

Time | Sales | Forecast

Jan   | $2$00 | $200

.

.

April | 0        | $30