Month to date total

Reply
Frequent Learner
Posts: 1

Month to date total

I have a data set as follows:
SaleAmt Date
10 01JUN2016
20 02JUN2016
15 03JUN2016

I want to make create a new column with the month to date total which would look like:
MonthToDate
10
30
45

I believe I need to use the retain statement but I am totally stumped!
Super User
Posts: 19,167

Re: Month to date total

Yes, you need the RETAIN statement. However, the following also includes an implicit retain. 

 

 

Running_total + SaleAmt;

Ask a Question
Discussion stats
  • 1 reply
  • 231 views
  • 1 like
  • 2 in conversation