Help with Peek Function

[Esneider]

Hi,

It's possible solution this example using peek or Previous function?

Thanks,

[its_anandrjs]

Use Below(sum(Value1))

Take a straight table

Dimension:- Date

Expression:- sum(Value1)

Expression:- Below(sum(Value1))

Expression:- Below(sum(Value1)) -sum(Value1)

Or You can use

Dimension:- Date

Expression:- sum(Value1)

Expression:- Below(Value1)

Expression:- Below(Value1) -sum(Value1)

In front end you are able to do this.

Regards

[tresesco]

In the front end, try like = Below(Value1)  

[Anonymous]

Hi William,

         Please find the attached application n according to your requirement.

Date	Value1	Value2	Result	Actual_Result
1/1/2014	10	20	10	10
1/2/2014	20	30	10	10
1/3/2014	30	45	15	15
1/4/2014	45	50	5	5
1/5/2014	50	60	10	10
1/6/2014	60	90	30	30
1/7/2014	90	900	810	810
1/8/2014	900	1000	100	100
1/9/2014	1000	2500	1500	1500
1/10/2014	2500

SHAIK