Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I have a problem with the average of accumulated values, per day, in a pivot table.
For example:
Date Values
01/08/2013 - U$400,00
02/08/2013 - U$500,00
03/08/2013 - U$300,00
04/08/2013 - U$400,00
05/08/2013 - U$400,00
06/08/2013 - U$500,00
Ok. And now, I want a expression to get the average of accumulated values, per day.
Like this:
Date Values Average of Accumulate Values
01/08/2013 - U$400,00 U$400,00
02/08/2013 - U$500,00 U$450,00
03/08/2013 - U$300,00 U$400,00
04/08/2013 - U$800,00 U$500,00
05/08/2013 - U$400,00 U$440,00
06/08/2013 - U$600,00 U$500,00
See? The expression will be some like "Accumulated values in that month until that day / number of days until date I want".
I don't know if my explanation is clear, but it's something like that. In the example with values, are more clear.
How can I do that? Have some way?
Thank you!
Try: RangeAvg(above(sum(Values),0,RowNo()))
The average for 05/08/2013 is 480 afaict though, not 440.
Try: RangeAvg(above(sum(Values),0,RowNo()))
The average for 05/08/2013 is 480 afaict though, not 440.
Thank you man!!! Works perfectly!!