November 17, 2021
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