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
Solved! Go to Solution.
Thank you everyone for your reponses, but all the solutions provided are not working.
I have tried this solution, to get Previous Data in a separate table and join it to my original table using a new generated key and playing with the quarter number.
'Q'&num(SubField(Quarter,'Q',2)+1) &'-'&DIM1&'-'&DIM2&'-'&DIM3 as Key_quarter,
Sum(PRIMES) as PrevPRIMES
Group by Quarter,DIM1,DIM2,DIM3;
It worked perfectly.
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
Actually the Expected Result is:
Can you do this?
How about this:
If(AutoNumberHash256(DIM1, DIM2, DIM3)
= Previous(AutoNumberHash256(DIM1, DIM2, DIM3)),
) as Prev
ORDER BY DIM1, DIM2, DIM3, Quarter