Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
Hi,
What is the output you want from the above example?
Hi qliksus,
Thanks for Reply,
Here my need is to Calculate FieldB
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.