how do i get previous date value of yesterday on my pivot or straight chart

[#1]

See attached

[sinanozdemir]

Something like this:

[effinty2112]

Try this which creates a field in the load script:

TempData:

LOAD Date(Date) as Date,

     LT,

     [Net val]

FROM

Book2.xlsx

(ooxml, embedded labels, table is Sheet1) ;

NoConcatenate

Data:

LOAD

if(LT = Previous(LT),Previous([Net val]),0) as [Previous Net val],

* Resident TempData Order by LT, Date;

DROP Table TempData;

This is the table produced:

Date	LT	Net val	Previous Net val
30/10/2015	LT 30	0	0
30/10/2015	LT 31	67236	0
01/11/2015	LT 30	0	0
01/11/2015	LT 31	0	67236
02/11/2015	LT 30	0	0
02/11/2015	LT 31	0	0
03/11/2015	LT 30	0	0
03/11/2015	LT 31	0	0
04/11/2015	LT 30	4082	0
04/11/2015	LT 31	4082	0
05/11/2015	LT 30	10936	4082
05/11/2015	LT 31	10936	4082
06/11/2015	LT 30	22412	10936
06/11/2015	LT 31	22412	10936
07/11/2015	LT 30	0	22412
07/11/2015	LT 31	0	22412
08/11/2015	LT 30	26810	0
08/11/2015	LT 31	26810	0
09/11/2015	LT 30	27479	26810
09/11/2015	LT 31	27479	26810

[HirisH_V7]

Hi,

Check this,

Check out attached,

Thanks ,

Hirish

[tamilarasu]

Hi,

You can also try the below method,

[Anonymous]

Make a Variable 'vPreviousDate' =max(date)-1

further call this variable using set analysis like.

Sum({<CalendarDate={'$(vPreviousDate)'}>}Amount)

[nagarjuna_kotha]

Like this?