This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Sorry, I think I misunderstood the first time. You don't need to see the current average of the last three months, you need to see the average for any given month and the two months prior, is that correct?
This should get you there:
In the Multi-Row Formula tool, you'll need to decide how you want to handle the first two months using the "Values for Rows that don't Exist" dropdown.
Hi Dan... thanks for the reply. it worked really well.
let me ask just one more question.. let´s say that i wanna add another dimension, for example:
M07/2017- CRF - $130
M07/2017- OTHERS - $110
M08/2017- CRF - $150
M08/2017- OTHERS - $105
M09/2017- OTHERS - $150
M09/2017- CRF - $165
M10/2017- CRF - $180
M10/2017- OTHERS - $180
M11/2017- OTHERS -$190
M11/2017- CRF -$190
Then.. the average last 3 months should be
Month Value ACCOUNT AVG
M11/2017 $190 CRF $181.66 (which means M11 + m10 + m09/3 - but - only the values that represents the account CRF)
M11/2017 $190 OTHERS $173.33 (which means M11 + m10 + m09/3 - but - only the values that represents the account OTHERS)
M10/2017 $180 CRF $168.33 (which means M10+m09+m08/3)
M10/2017 $180 OTHERS and so.............
based on your logical it won't work because your multiple row is configured to work with the dates, am i right? are there any way that i can add another dimension and just do the average for each account?