Jump to content
We've recently updated our Privacy Statement, available here. ×

MTD Calculation Columns


Marcos Morales

Recommended Posts

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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...