Forum Discussion
Pivot Table - Summing Averages in Grand Total
I have a column of values in a pivot table summarized as averages. I want the grand total for this column to add the averages as a sum. I know I can manually add the values with a simple formula. But...
If add data to data model you may play with DAX measures. For such model
it could be
average with sum:=SUMX (
SUMMARIZE (
Table1,
Table1[A],
"averages", AVERAGE ( Table1[V] )
),
[averages]
)or
averages:=AVERAGE( Table1[V] )
average with sum 2 :=
SUMX (
VALUES ( Table1[A] ),
[averages]
)
