Subtotal and Grandtotal to Show the Averages of each Monthly Total

[polaris3028]

Hi Gurus,

I have this table below that needs to show the average of each month in the subtotal for each assignee and the grand total to show the average of each subtotal.  

 

Same goes if this table expands with multiple assignees, where it should calculate the average of each assignee subtotal.

Any help would surely be appreciated. 🙂

[v-yulgu-msft]

Hi @polaris3028,

Per my knowledge, it is not possible to show the average of detailed values in subtotal row and show average of each subtotal in grandtotal row. By default, both grandtotal and subtotal calculate results with SUM aggregation. Even if we generate a measure to get AVERAGE rather than SUM, the measure will calculate based on detailed rows. That is to say, it is not possible to calculate based on subtotal level.

Regards,

Yuliana Gu