For the First week i.e, W1, Decision should be Zero.
Decision = 0
I have a formula i.e., Decision(W2)=RFS3(W1)+RFS3(W2)-Decision( W1)
Decision(W3)=RFS3(sum of W1,W2,W3)-Decision( sum of W1, w2)
This should continues for all the weeks,
Like For 15th week,
I have tried using addcols and sum commands but did not find the solution.
After doing this, I have to create a column chart to show all the values on the column if I place cursor over that bar.
for week1, all the details like code, week, previous total of rfs3, current rfs3, previous decision and current decision.
I have used like below:
| eval All_details=tostring("Week: ")+'WEEK'+tostring(", CODE: ")+'CODE''+tostring(", Current Week RFS3: ")+'RFS3'+tostring(", Next Week RFS3: ")+'prev_RFS3'+tostring(", Previous decision: ")+'prev_decision'+tostring(", (Current Week RFS3+Next Week RFS3-Previous decision)= Current decision: ")+'decision'
It is giving me all the details in a single line. But I want code in a line, week in a line and rfs3 in a line and soon.
Also If I use chart by count command for the concatenated value, it is showing 15 records of data in the column chart and next records of data like other. How to show all the records in the chart.
Please help me to solve all my queries, a little urgent.