Accummulation based on 2 dimensions (Date and Properties)

[kumarnatarajan]

Hi All,

I have the below values.

Date	Properties	Value
11/12/2012	Fridge	20
11/12/2012	A/c	30
12/12/2012	Fridge	30
12/12/2012	A/c	40
12/12/2012	TV	60
13/12/2012	Fridge	70
13/12/2012	LCD	40

i need the output in the below format where this has to be handled at front end and not at the script level.

Date	Properties	Value	OutPut
11/12/2012	Fridge	20	20
11/12/2012	A/c	30	30
12/12/2012	Fridge	30	50
12/12/2012	A/c	40	70
12/12/2012	TV	60	60
13/12/2012	Fridge	70	120
13/12/2012	LCD	40	40

The sort order should be Date 1st and then Properties.

NOTE: it works for me when properties column is sorted first either ascending or descending,

BUT it should work with date sorted first.