I need help to reply this excel report on Qlikview, maybe someone have the same need. This report seeks to identify the time with which the customer remains with the contracted service.
The First table:
Altas = New Sales
Bajas = Loss Sales
The first table is simple to work with. The new sales information by period is shown as well as the lost by period. Both amounts are subtracted and accumulated month by month. This accumulation I solved using As of Periods (Rolling To date).
My problem is for thi other tables that this report has. I'm Attaching the Excel Report with the formulas to do the differents calculations.
if someone has something similar or can give me an idea to reply this excel, i'll I appreciate it.