How can I access the previous data based on previous date condition where the value Exists?

[#1]

Hello Everyone,

How can I access the previous data based on previous date condition where the value Exists?

Like

I am making a table

FieldA     FieldB                         Product

01-02-2013     234                         A

02-03-2013     (234)+100                A

03-04-2013     (234+100)+100         A

Please help.

Thanks in Advance,

[qliksus]

Hi,

What is the output you want from the above example?

[#3]

Hi qliksus,

Thanks for Reply,

Here my need is to Calculate FieldB

[qliksus]

Hi,

If you want in Script then,

Please go to Help -> Peek

Load A, B, NumSum( B, peek( 'Bsum' ) ) as Bsum...;
creates an accumulation of B in Bsum.

It will help you , but before that u need to create a table which have only required field

If you want in Chart level,

Then use rangesum function.