I'm working on a dashboard that receives data from systems that present statistical data.

Over a day I can have multiple rows with statistical data like, average, standard deviation and number of units.

When I want at the bottom of every row a total, I can not simply use any of the standard functions of the picot table, as I need to calculate a weight Average of the Average column and use a special formula for the standard deviation.

As an example in a Table I can simply do the weight Average with the below formula. 

=[[#Totals];[Sumx]]/[#Totals];[n]]  #the "Sumx" is also a value that is available. 

Is something like this also possible in a pivot table?

I use office 365