Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
is this what you want ?
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
Any luck on this Aditya?
Hi Sada,
Please Find attached app.
Thanks,
Arvind Patil !
Hi Aravind, can you share QVF of this..
Thanks
wait..
HI Sada,
Please Find Attachment.
Thanks,
Arvind Patil
Hi Aravind,
Thanks for the reply,
This was my actual problem. can you try this?
Regards,
Sadasiva
will try
Thanks,
Arvind Patil