Previous

[soha1902]

Hi All,

I have following Data:

Load * Inline [
Date,Sales
12/12/2014,50
01/01/2015,100
01/02/2015,200
01/03/2015,300
01/04/2015,500
01/05/2015,600 ];

Tab1:
Load
Date as Date,
Sales as Sales,
Previous(Previous(Sales)) as PreSales
Resident Tab;
Drop Table Tab;

As of now in "Presales" column I am getting values of last 2 days but in future this value will be change for last 5 or some other number.

So please let me the dynamic way which I can use in place of previous.

[soha1902]

it gives only sum of previus(Sales) + First value of sales. but I want sum of previous, plus all the record till first record.

[sunny_talwar]

This?

Tab:

Load * Inline [

Date, Sales

12/12/2014, 50

01/01/2015, 100

01/02/2015, 200

01/03/2015, 300

01/04/2015, 500

01/05/2015, 600

];

Tab1:

Load Date,

  Sales,

  RangeSum(Peek(Sales, -1), Peek(Sales, -2), Peek(Sales, -3)) as PreSales

Resident Tab;

Drop Table Tab;

[SreeniJD]

Hi There,

are you looking something like...

RangeSum(Previous(Sales),Peek(Sales)) as PreSales..

which will give you 1000 if you select 01/05/2015..

Happy to help

Sreeni

[Digvijay_Singh]

Something like this -

Tab1:

Load

Date as Date,

Sales as Sales,

RangeSum(Sales,Peek('PrevSales',-1)) as PrevSales

Resident Tab;

Drop Table Tab;

[Anonymous]

hi soha

Please see below post:

Peek() or Previous() ?

[SreeniJD]

Soha -

Are you looking for the desired results as mentioned in below tables (1st refers to presales by year, second one is across years)... Please clarify.

Date	Sales	PreSales
12/12/2014	50	0
01/01/2015	100	0
01/02/2015	200	100
01/03/2015	300	300
01/04/2015	500	600
01/05/2015	600	1100
Date	Sales	PreSales
12/12/2014	50	0
01/01/2015	100	50
01/02/2015	200	150
01/03/2015	300	350
01/04/2015	500	650
01/05/2015	600	1150

Sreeni

[soha1902]

This is correct sunny. I am looking the same but suppose I want to add last 30 days then I need to write 30 Peek(). How I will do the same in dynamically.

Thanks.

[sunny_talwar]

For dynamic solution, you might have to use Loop. I don't think there is an easier solution.

Best,

Sunny