Hi ,
How to build the following chart :
| Input |
| Trading Day | 1 | 2 | 3 | 4 | 5 |
| Sales | 500 | 1000 | 2000 | 500 | 1000 |
| Budget | 0 | 0 | 20000 | 0 | 0 |
| Budget=20000/5 is 4000 |
| Output |
| Trading Day | 1 | 2 | 3 | 4 | 5 |
| Sales | 500 | 1500 | 3500 | 4000 | 5000 |
| Budget | 4000 | 8000 | 12000 | 16000 | 20000 |
Please find the attachement sample
In the sample model . I am using vPerFormula and vPerFormulaBud to calculate the sales and budget resp.
For the Sales Value and Budget Value calculation I need to use the variables vPerFormula and vPerFormulaBud.
By using the variables I need to build a chart . by Trading Day and the cummulative sum
My requirement is :
The output needs to be reflected in the chart.
pfa.
