Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
I want to show in a graph the cumulative reduction of m2.
These are my variables:
These steps I have to take (I think)
Per Period:
(Get the aggregated sum of M2 s, where Status_property is not equal to "Sold" or "Rent expired" for the recent month
minus
Get the aggregated sum of M2 s, where Status_property is not equal to "Sold" or "Rent expired" for the previous month)
However, this will show me the reduction for each month and not the cumulative reduction. Also, I cant manage to get this in a code.
Help would be appreciated!
Would you be able to share a sample or sample data with the expected output to help you better
Ha Sunny,
sorry for the delayed reply.
Here is a picture. Left u see a small table with some relevant sample data.
What I want to achieve is the following (see tabel on the right side):
I want to show the cumulative volume of reduction per Year-Month in a graph. The volume should be equal to the volumes which are marked red in the right side table.
So during 2019 there has been 3 changes:
So I am wondering what the code is to get the same results as posted in the laste line of the right table (the figures in red).
I hope you can help me.
Kr
Martijn
Would you be able to share the sample data as text instead of image?