Hello, expert friends. On this occasion I turn to his powerful knowledge in data transformation. It is possible to obtain the following data transformation.
My initial data:
base_temp:
load * inline [
Periodo, Customer, Venta
201701,A,100
201702,B,200
201703,C,300
201704,A,400
201705,B,500
201706,C,600
201707,A,700
201708,B,800
201709,C,900
201710,A,1000
201711,B,1100
201712,C,1200
201801,A,1000
201802,B,2000
201803,C,3000
201804,A,4000
201805,B,5000
201806,C,6000
201807,A,7000
201808,B,8000
201809,C,9000
201810,A,10000
201811,B,11000
201812,C,12000
];
The transformed data that I want to obtain:
- Rango: Calculated field. If 201701 => 201701 - 201701; if 201703 => 201701 to 201703. .....
- Total Venta: accumulated sum accumulated sum according to the rank (rango)
