Marcos Morales Posted May 27, 2019 Share Posted May 27, 2019 Hi Experts, Im new in this wordof analytic and I need to create a calculation to express the MTD, using a columns with a date and another with amount, like this: Date Ammount MTD 10/2/2018 5 5 10/3/2018 23 28 10/4/2018 34 62 10/5/2018 34 96 11/1/2018 57 57 11/2/2018 40 97 11/3/2018 40 137 11/4/2018 70 207 11/5/2018 35 242 11/6/2018 45 287 12/1/2018 24 24 12/2/2018 40 64 12/3/2018 70 134 12/4/2018 70 204 12/5/2018 35 239 12/7/2018 45 284 1/1/2019 80 80 1/2/2019 40 120 1/3/2019 70 190 1/4/2019 66 256 I will apreciate your help best regard Marcos Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now