Pivot Table - Summing Averages in Grand Total

[Bjsmith2]

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 is there a way to adjust the field settings to do the aforementioned?

[#2]

@Bjsmith2 

Not as far as I know.

Keep in mind that a sum of averages is meaningless.

[#3]

@Bjsmith2 

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]
)