Hi guys,

I have a headcount data. I groupped them according to dates (months/quarters and year) in pivot table. I have personnel numbers and dates. I want to see average personnel numbers for quarters and total, I dont want pivot to sum each month. I found that it can be done through pivot table-new measure but I could not write the correct formula for this. Can you please help? Thanks in advance.


foto.JPG