I have a problem to calculate a year average.
I have four date field:
If I set a filter for example Year = 2016, Month = 11 and Day=28
I get only the amount for the date 28.11.2016
At the same time I want to have a year average to my "Year" Filter.
So that I have two values.
The first value ist der amount for the date 28.11.2016
and the second vaule should be the yaer average for 2016.
Thanks a lot for your help.