Placing the avg. of all range, in every row.

[countryfan_nt]

Hello friends, hope all is well!

please help me; I want to place the average of all the rows, in a column, where every field shows that total average in each row.3
the attachment should clarify what is needed.

thank you very much in advance!

[than_gold]

Hello,
in Cell G4 use "=AVERAGE($C$4:$C$12)" and copy +paste to all cells till G13

[sandy666]

Is that what you want?

[countryfan_nt]

thanks to you all! Sandy how did you do it? awesome

[sandy666]

In DataModel I added Calculated Column: AVG.Total with = AVERAGE([amount]) then PivotTable from DataModel. That's all