Hi all,
I have a sample excel file with contain 2 years of Margin figure.
I wanna get a accumulated margin from the beginning of the year till the latest month period.
The box current showing the total of whole year 2017 Margin which is wrong.
It should be 550 (a sum up of 201701-201704).
For example, now the current year month is 201804. The box should show the sum margin figure of 201701-201704.
When i filter it to 201803, then the box should show the sum margin figure of 201701-201703.
Hope you guys could understand what i mean.
Please find attached as my all required file.
