calculate sum month and annual

load Export_T1.mat
whos
  Name           Size             Bytes  Class    Attributes

  T_          5710x2             663961  table              
  ans            1x38                76  char               
  cmdout         1x33                66  char               
head(T_)
         T1               T2     
    _____________    ____________

    "01-Jan-2008"    "0"         
    "02-Jan-2008"    "0"         
    "03-Jan-2008"    "0"         
    "04-Jan-2008"    "0"         
    "05-Jan-2008"    "0"         
    "06-Jan-2008"    "-49640"    
    "07-Jan-2008"    "137800"    
    "08-Jan-2008"    "-107331.75"

Ewwwww....everything is a string, not native date types...gotta' fix that first; that's not what your original post says the variable types are/were...

T_.Properties.VariableNames={'Date','Profit'};  % make more meaningful names
T_=convertvars(T_,{'Date'},'datetime');         % convert types
T_=convertvars(T_,{'Profit'},'double');
ttT=table2timetable(T_);                        % now convert to timetable
clear T_                                        % no sense keeping two copies same thing in memory
format bank, format compact                     % "profit" implies currency format
head(ttT)                                       % see what we gots now...
       Date          Profit  
    ___________    __________
    01-Jan-2008          0.00
    02-Jan-2008          0.00
    03-Jan-2008          0.00
    04-Jan-2008          0.00
    05-Jan-2008          0.00
    06-Jan-2008     -49640.00
    07-Jan-2008     137800.00
    08-Jan-2008    -107331.75
pByYear=retime(ttT,'yearly',@sum);
pByYear.Date=dateshift(pByYear.Date,'end','year')
pByYear = 16×1 timetable
       Date          Profit  
    ___________    __________
    31-Dec-2008    1869053.06
    31-Dec-2009       9218.00
    31-Dec-2010     776858.50
    31-Dec-2011       4170.25
    31-Dec-2012      53796.25
    31-Dec-2013      71171.00
    31-Dec-2014      81188.00
    31-Dec-2015      25270.00
    31-Dec-2016      19488.75
    31-Dec-2017      12759.50
    31-Dec-2018      30552.25
    31-Dec-2019      33090.50
    31-Dec-2020      61167.00
    31-Dec-2021      52313.25
    31-Dec-2022      61586.50
    31-Dec-2023       6749.50
pByYear.Date.Format ='yyyy'
pByYear = 16×1 timetable
    Date      Profit  
    ____    __________
    2008    1869053.06
    2009       9218.00
    2010     776858.50
    2011       4170.25
    2012      53796.25
    2013      71171.00
    2014      81188.00
    2015      25270.00
    2016      19488.75
    2017      12759.50
    2018      30552.25
    2019      33090.50
    2020      61167.00
    2021      52313.25
    2022      61586.50
    2023       6749.50

Monthly shouldn't be hard to guess! :)

@doc:dateshift

piero 2023-8-15

i'm using google translate :D

Image Analyst 2023-8-15

It's weird that Google translate does not know that "i" and "i'm" should always be capitalized in English. And they should always capitalize their name, as with all proper names, and the first letter of each sentence.

请先登录，再进行评论。