How to get average of Cumilative sum values

[Anonymous]

Hi Team,

I am having numbers need to be added as cumilatively. Range sum() will do that. After that i need to get average of those numbers monthly. I am having 5 years of data.

For example

   In this case if i want to calculate Avg for May-17 i need to consider (72+102)/2 insted of (12+30)/2

monthyear	Value	Range sum
Jan-17	15	15
Feb-17	20	35
Mar-17	25	60
Apr-17	12	72
May-17	30	102

How can i achieve this. Thanks in advance.

Regards,

Sadasiva

[#2]

[#3]

is this what you want ?

[Anonymous]

Hi Aditya,

We are almost there, but the thing is i am not seeing those numbers by time dimension, and Time dimension is the filter.

Lets say am selecting year 2017 it will consider all the months from Jan2017 to June2017 and calculate the average of those closing stock numbers.

Regards,

Sadasiva

[Anonymous]

Any luck on this Aditya?

[arvind_patil]

Hi Sada,

Please Find attached app.

Thanks,

Arvind Patil !

[Anonymous]

Hi Aravind, can you share QVF of this..

Thanks

[arvind_patil]

wait..

[arvind_patil · Accepted solution]

HI Sada,

Please Find Attachment.

Thanks,

Arvind Patil

[Anonymous]

Hi Aravind,

Thanks for the reply,

monthly average inventory?

This was my actual problem. can you try this?

Regards,

Sadasiva

[arvind_patil]

will try

Thanks,

Arvind Patil