cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

Subtotal and Grandtotal to Show the Averages of each Monthly Total

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.  

 Capture.PNG

 

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. 🙂

 

1 REPLY 1
Highlighted
Microsoft
Microsoft

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors