Need help in a complex expression(Converting Excel formulae to expressions)
I have a excel sheet which contains data of which one coloum is calculated based on the previous coloumn value with a formule
=1+SUM(B5:B$12)/SUM(B$2:B3) where B represents the previous coloumn . I trying to replicate the same sheet in qlikview pivot object .
I am not been able to found the solution to this formulae in expression . I am attaching the sample application as well as the Excel sheet which contains the report which i want to replicate in qlikview .
Can any one help me or is this even possible in qlikview application ?