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.