Increase portfolio turnover

[#1]

Hi everbody,

I'm having a problem with determing the weekly increase in the portfolio turnover. I can get the figure for each week, but i also want to see the result from last week to detemine the delta (increase or decrease).

Week	Turnover portfolio	last week	Delta
45	1000
46	1100	1000	100
47	1050	1100	-50
48	1000	1050	-50
49	1100	1000	100
50	1150	1100	50

What would be the code for the last week data. The fields i use are Week and sum(Sales) for the turnover.

Hope somebody can help me.

Thanx

Niles

[#2 · Accepted solution]

Hi Niles,

I hope, it is not too late

I have done it like follows: I have load your week and Turnover in an Inline-Table called table1.

table2:

load

     week, turnover, week-1 AS pre_week

resident table1;

join load

     week - 1 AS pre_week

resident table1;

left join load

     week AS pre_week, turnover AS pre_turnover

resident table1;

Then you can sum in an pivot or sum table the turnover, the pre_turnover. For the delta you could use if(sum(pre_turnover) <> 0, Sum(tunrover) - Sum(pre_turnover)).

regards

vicky