Get Previous Values

[zjalalacssi]

Hi Everyone,

I have the sample data below and i would like to get the Previous Value Column,

For each Quarter, get the value of the previous one, either in the script or in the chart

Thank's in Advance

[vishsaggi]

Try this in your Straight table expr

= IF(RowNo(TOTAL) = 1 OR RowNo(TOTAL) =2, 0, Above(TOTAL Sum(Value),2))

[eduardo_dimperio]

SCRIPT:

LOAD

VALUE

PEEK(VALUES) AS PREVIOS VALUE

RESIDENT YOURTABLE

ORDER BY

ASC VALUE;

[zjalalacssi]

Hello,

Thank you for your reply

This is the result i get when applying your formula.

Note please that in my final Table i won't need the Quarter anymore.

Thank you very much

[vishsaggi]

Ok, is that not your expected output? if not what should be your expected output please let us know.

[zjalalacssi]

Actually the Expected Result is:

Quarter	DIM1	DIM2	DIM3	PRIMES	Prev
Q1	D1	DD1	DD1	10
Q2	D1	DD1	DD2	20	10
Q3	D1	DD1	DD3	30	20
Q4	D1	DD1	DD4	60	30
Q1	D2	DD2	DD5	100
Q2	D2	DD2	DD6	200	100
Q3	D2	DD2	DD7	300	200
Q4	D2	DD2	DD8	400	300

Thank you

[Anil_Babu_Samineni]

Can you do this?

Aggr(Above(Sum(PRIMES)), DIM1)

[Anonymous]

try this on your Previous Field expression in straight table..

aggr(above( aggr(PRIMES,DIM1,Quarter)),DIM1,Quarter)

[jonathandienst]

How about this:

LOAD Quarter,

     DIM1,

     DIM2,

     DIM3,

     PRIMES,

     If(AutoNumberHash256(DIM1, DIM2, DIM3)

          = Previous(AutoNumberHash256(DIM1, DIM2, DIM3)),

          Previous(PRIMES)

     ) as Prev

FROM  ....

ORDER BY DIM1, DIM2, DIM3, Quarter

[Anonymous]

aggr(above( aggr(PRIMES,DIM1,Quarter)),DIM1,Quarter)