Display average for monthly values on yearly basis

Dear Community,

I was wondering how it is possible to display a column with averages like you see it in the following screenshot:
Unfortunately did not find any solution but it seems for me a basic request.
I can only display the totals for columns which is not very helpful when summing up FTE´s of cost centers for each month. Average makes more sence in this case.

Thank you

All the best
Daniel

Hi @de.schmidd
a few ideas

  1. What if you change the aggregate for the FTE to AVG.
  2. What if creating a calculated field (avgOver), use the same table structure just with the new field and place it behind the current one that only the avg column is visible.
  3. A combination of 1 and 2.
    BR

Hi @de.schmidd
an update on your side?
BR

thanks. I guess this works