Total average column

[thampton]

Sample data below. Is it possible to add a total average coumn as shown below in a matrix? I do not want an average under each day. 

	1/1/2018	1/2/2018	1/3/2018	Total	Average
John	5	10	15	30	10
Jane	2	4	6	12	4

[Omega]

Drag the same measure/column used to calculate total, say data, in the Values field and change the summarization to Average. In values field, data column will be repeated twice. 

[thampton]

Is there a way for it to only show the average that is next to the total and not the averages in the invididual columns?

[Omega]

Try creating a new measure, using Average () and ALL () functions

[thampton]

Is there a way to only populate the final average? I dont need to see the daily averages. 

[themistoklis]

@thampton

Row Subtotals should be off. Then yoy sould only see the grand total

See image below:

[Omega]

What do you mean by final average? Do you mean the total for all days and customers & then divide the by total number of days?