Averaging within a time period

[#1]

Hello

Simple query , I have a € value which is captured daiily on each business day of the month, I want to average that number for each month rather than ovver the entire data range . Any Ideas .

Thanks

[#2]

Use month as dimension in your graph/table. Then it should give you your average per month.

=avg(EUROAMT)

If you don't have month as dimension just create it with

month(DateField) as Month

or

year(DateField) & '-' &month(DateField) as YearMonth

/F