How to add an average total of sum values in pivot table with running columns ?

[szakharov7723]

Hello

Basically I want to have a pivottable like below[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 500"]
<tbody>[TR]
[TD]Center[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]Total average of DT%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Sum of DT%[/TD]
[TD]Sum of DT%[/TD]
[TD]SUM of DT%[/TD]
[TD]SUM of DT%[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Center Name[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


Sorry if it looks messed, first time on forum.
The issue is I can't just put total average after pivot table, because once new week is entered this column will get destroyed.
As well as I can't make grand total calculate average, as then it will convert sum of DT% to average of DT%.
I tried to dig into DAX (powerpivot), but couldn't understand it.
I don't necessary need Total average of DT% to be in pivot table, but I just need it to be consistent and follow the design.
Can you please help me out.

 

[SpillerBD]

As with all things new, you just don't get it till you get it.

However, two online resources, TouTube channels to check are:
Mike Girvin's, Excel is fun. Look for his playlist, Excel 2013 Power Pivot.
Avi Singh - PowerBIPro and find his playlist PowerBI for Beginners and Excel Users.
P3, PowerPivotPro - Less material on their Youtube, but Rob Collie (P3 founder) and Avi have a series of books that are some of the best.

Other book authors to look at are the sometime collaborators, Alberto Ferrari & Marco Russo.

Lastly, there are better DAX guys on the forum if this initial thread doesn't get lost. Some may be able to give the PowerPivot formulas if they have the exact field names you are working with. I'm still scrambling up the learning curve, but see the potential. Already pleased with the ETL of PowerQuery.

[h=1][/h]