Forum Discussion
Need for a pivot table in the subtotal row the sum of column with averages.
Hello, I need some help with totals and subtotals in a pivot table I want that the subtotal row of a column with averages the sum is of the items and not the average of the items. I attachment y...
That is if you are not on Mac.
Creating PivotTable add data to data model
and when create two measures (in Power Pivot or right click on table name in PivotTable pane)
MD Average:=AVERAGE(_C70_ALMM_Extended[MD])
and
Sum by day MD Average:=SUMX( GROUPBY(_C70_ALMM_Extended, [RF]), [MD Average])and use second one in PivotTable
Average of MD here is built-in measure and here is only to compare, you don't need it.
Please check in attached file.
- Thanks for sharing the example XLSX. This solved my problem.
estoll2440 , you are welcome
Good one SergeiBaklan
Another way to write the same measure...
Sum by day MD Average2 := SUMX ( VALUES ( _C70_ALMM_Extended[RF] ), [MD Average] )- Thank you for the answer. It's also nice to get more than one solution.
I understand the solution but I'm still trying to apply to another sheet. You are right, thank you.
- SergeiBaklan
Thanks! My pleasure!
