Hello everyone, I have data that all customers have different periods of payment. I have colomns for remaining periods and payments. I need to create colomn(a) and sum rows based on period. For example, the customer has 10 period payment. I have 10 rows for that customer. For period 1 I have to sum all rows of payment and for period 2 I have to sum first 9 rows. (Basically I have to sum rows for remaining_period-period) Also, I need to get value of specific row. For example, the customer that I mention above. If I am in period 1, I need to get 10th row value from another colomn. For period 2 I need to get 9th row value etc. Thanks for your help.
... View more
