Hello,
It seems more like an algorithm problem.
I guess your "Total amount" column is an objective and you want to do a projection, depending on capacities produced every year, to determine how many years you need to achieve this objective?
Once you have determined how many years you need you will be able to add columns (or display them like said by Eitan Rosenberg).
In pseudo code it should be like :
DATA data_table structured like :
total_amount type amount,
year_1 type amount,
year_2 type amount,
...
year_10 type amount,
.
CLEAR max_columns_needed.
LOOP AT data_table.
CLEAR l_objective_acheived.
l_nb_year_needed = 1.
WHILE l_objective_acheived < data_table-total_amount
AND l_nb_column_needed <= 10.
* CONDITION 1 : reach the objective
CONCATENATE 'DATA_TABLE-YEAR_' l_nb_year_needed into l_column_name.
ASSIGN (l_column_name) to <year_column>.
add <year_column> to l_objective_acheived.
* CONDITION 2 : reachable objective
IF max_columns_needed < l_nb_column_needed.
l_nb_column_needed = l_nb_column_needed.
ENDIF.
ADD 1 TO l_nb_column_needed.
ENDWHILE.
* HERE : l_nb_column_needed contains how many years are needed to reach* total_amount of the current line,
* OPTIONAL : with 2 additional fields in DATA_TABLE you can save
* l_nb_column_needed and l_objective_acheived for each line (for debug * or display)
ENDLOOP.
* HERE : max_column_needed contains the number of "year column"
* you have to display (from 1 to 10).
