Calculate from Previous record

[#1]

Hi Everyone,

Can somebody help me how to calculate data from previous entry?

Please note that I use a cross table.

Temp1:

CrossTable(MONTHMMC, [DataC], 2)

LOAD YEAR_ as YYYYC,TYPE_ as [TYPEC],A01 as APR,A02 as MAY, A03 as JUN,A04 as JUL,

     A05 as AUG, A06 as SEP, A07 as OCT,A08 as NOV,A09 as DEC,A10 as JAN, A11 as FEB,

     A12 as MAR,TTL as TTL

FROM

[..\Data\QVD\C_OUT.QVD]

(qvd);

Concatenate(Result)

LOAD * Resident Temp1;

DROP Table Temp1;

It should compute this way. Can this be done on the expression of Chart Properties?

       

Thank you,

[avinashelite]

Hi Esmark,

Please use the Rangesum and above function together.

Please find the attachment for the sample qvw

Regards,

@vi

[tresesco]

Have a look at above()/below() /before()/after(). If you are using a straight table, below() would be helpful, if pivot - after().

[#4]

PFA the attached solution.

[#5]

Hi All,

I am using this expression in getting each column value.

How will I use the before() or RangeSum() using the below definition?

[#6]

Hi Shrivas,

I tried to use the expression you've made but I got this.

[avinashelite]

Hi Esmark,

Do you need to hard code all the months as an Expression????.

Insted of that you can use a Pivot table and do the pivoting rite???

Please find the attachment, hope it helps you.

Regards,

@vi

[#8 · Accepted solution]

I think this is want you need.

[#9]

Thank you everyone.