how to create cumulative growth in straight table?

[jim_chan]

Hi guys, 

I have a requirement. 

I need to create a expression to calculate the cumulative growth. 

Example: for Feb-18the cumulative growth is value of Feb - 13900-13000(base_amt) = 900. Then march is mar value 13700-13000 = cummulative growth from feb to mar is 700. 

Then, add/sum up the cumulative growth = 900+700= 1600. 1600 is the cumulative growth.

I really dont know how to write in script, please help guys.

Rgds

Jim

[sunny_talwar]

You want this 1600 to be in a text box object? and also, base_amt is a field from the script? May be just do this

=Sum(value - base_amt)

[jim_chan]

Hi sunny,

I want the 1600 to be in the straight table like the screenshot as per attached, sunny. But I dont know how to do it.

Rgds

Jim

[sunny_talwar]

I guess you need to remove your month-year and value dimensions to get 1600

[jim_chan]

The base amt 13000 is based on country . Each country has an amt. Eventually, it will be a manual file and load into the script.

[jim_chan]

Cant remove the month year, as per requirement.