how to get the difference in rows group by each person and date.

[prasad]

Nameofperson	Dateofweight	Weight	Difference
aa	13/01/2013	55
aa	14/01/2013	65	10
aa	16/01/2013	55	-10
aa	20/01/2013	73	18
bbb	13/01/2013	42
bbb	14/01/2013	40	-2
bbb	16/01/2013	35	-5
bbb	20/01/2013	40	5
bbb	25/01/2013	37	-3
bbb	30/01/2013	33	-4

In the above example, I am trying to get the difference between 2 dates (only negatvie nos only) for each person on different dates. Is there any function for this. Please guide onthis. Thanks in advance..

[maxgro]

if I understand your question try with a chart (straight table)

dimension

- name

- dateofweight

expression

- weight

- if(sum(Weight) -  Above(sum(Weight)) <0, sum(Weight) -  Above(sum(Weight)))

disable user sort

see attachment

[prasad]

ThankU very, much..I will try and update this ..