Has anyone tried to use Rangeavg function using Set analysis
Anyone having expertise in Set Analysis? I want to calculate Cumulative average against each Month and Year with 2 Years of Sales Data. Attached the Input file and QV file, if anyone can give an insight?
Re: Re: Has anyone tried to use Rangeavg function using Set analysis
Please find attached the result excel sheet, I would like to achieve.
Basically I am trying to calculate the Moving average, so For Jan it is to be Jan (Amount) by 1 and for Feb it will be Jan(Amount) + Feb(Amount) /2 and so on and when the year changes it needs to be reset.