Calculated Column required.

[varunvarma]

Dear all,

Greetings for the day. Please guide to achieve below requirement. Please look below image.

I need to create new column "NEW SALES". Formula is mentioned in image. i.e. SUM(last 8 years sales)

Please support to achieve this. Thank you in advance.

[deepakqlikview_123]

Cumulative sum in Qlikview

[anbu1984]

Check this app

Dim: Year

Expr: Rangesum(Above(total Sum(Sales),1,8))

[its_anandrjs · Accepted solution]

Hi,

Read this documents

Calculating rolling n-period totals, averages or other aggregations

Re: Accumulation Problem

Regards,

Anand

[jagan]

Hi,

Try like this

Dimension:YEAR

Expression: Rangesum(Below(total Sum(SALES),1,8))

Sort the Year in descending order.

Hope this helps you.

Regards,

Jagan.

[jagan]

Hi,

If you got the answer please close this thread by giving correct answer to the useful thread, it helps others in finding the answers.

Regards,

Jagan.