Calculating weekly growth

[#1]

Hi Guys,

I want to calculate weekly growth in a table. I have also attached a file which tells how my table should look like. I want to know that which expression should i use so that even if  change the sorting of data week coloumn, then also the growth should be correct for that corresponding data week. In simple words, my growth should be irrespective of the sorting of data week.

[#2]

I think you should use the Chart Inter Record Functions, like the Above() function to refer to other rows in the chart table. For example, the following expression: Sum(Sales) - Above(Sum(Sales))

[#3]

Thanks juan for the reply. I tried the same thing but then if i change the sorting of the column data week, then the growth will also change. I want an expression which should be irrespective of the sort order of data week.

[#4]

Hi ,

Why don't you calculate the growth in the backend , then sorting the column data week or any other column wont affect the growth calculation

[#5]

Hi

sum(([Net Amount]))-Above(sum([Net Amount]))

this expression is works

[#6]

Hi,

PFA.

Regards,

Kabilan K.