Hi veepsirtt,
If `dat` is the dataset library(dplyr) dat %>% group_by(DATE) %>% summarize(PROFIT=sum(PROFIT)) %>% arrange(desc(as.Date(DATE,format="%d/%m/%Y"))) Source: local data frame [4 x 2] DATE PROFIT 1 02/07/2014 -1350 2 01/07/2014 9400 3 30/06/2014 11325 4 27/06/2014 6850 If you just wanted to have a new variable subTotalPROFIT and not summarize the dataset dat %>% group_by(DATE) %>% mutate(subTotalPROFIT=sum(PROFIT)) %>% arrange(desc(as.Date(DATE,format="%d/%m/%Y"))) A.K. On Wednesday, July 2, 2014 4:03 AM, Velappan Periasamy <veepsi...@gmail.com> wrote: Hi A.K, How to Sort the given data.frame date wise in a descending order and getting date wise subtotal SLNO. DATE SCRIP PROFIT 6006302/07/2014Aluminium -1000 6005702/07/2014Copper 900 6005602/07/2014LEAD -1250 6002901/07/2014Crude Oil6400 6003401/07/2014LEAD 1500 6002501/07/2014Nickel 1500 5998030/06/2014Nickel 475 5998430/06/2014Natural Gas3000 5997230/06/2014Crude Oil2600 5997130/06/2014Copper3750 5997030/06/2014Natural Gas1500 5992427/06/2014Aluminium 500 5992227/06/2014LEAD 2250 5992027/06/2014Copper1100 5991827/06/2014Natural Gas3000 Thanks veepsirtt ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
