I'm a little confused on how to achieve this. It would be great if someone can help me with this. I have a table
Month | Name |
1 | sss |
1 | tt |
1 | uu |
1 | vv |
1 | ww |
2 | ss |
2 | tt |
2 | uu |
2 | vv |
I want to get an input from user (a number say 100) and based on the number of months available (here 2), I want to split it up for the two months. The complexity comes because I just want to populate the first row of each month with the divided value (50) Example output is below
Month | Name | Value |
1 | sss | 50 |
1 | tt | |
1 | uu | |
1 | vv | |
1 | ww | |
2 | ss | 50 |
2 | tt | |
2 | uu | |
2 | vv |
Solved! Go to Solution.
Hi @shravanvijayaprasad ,
Attached is an example showing how to do it.
Let me know if this works for you.
Best,
Fernando Vizcaino