Dear Colleagues, I'm trying to get a accumulated results that depends on the Product in a straight table but based on expression and not dimension.
Please see below one table with the example of expected results (last column)
I have tried to use above and it stop to accumulated when the week change. For RangeSum it accumulate all the period and not by product and the problem it doesnt work for expression.
I appreciate if somebody can give a good idea to share. I have added the Qlikview as example enclosed.
Dear Antonio, I'm trying to find a solution to accumulate a calculated expression. I would like to use the expression, since it depends on several other columns and this one should accumulate with other dimensions.
Do you believe there is any way to do in this way?