Thanks for sharing it, it’s much clearer now! Unfortunately, the underlying react library (react-pivottable) does not support multiple average-aggregator, so I don’t think it’s possible to do this without modifying how pivottable.js works behind the scene.
One hypothetical way to approach this with Dash would be to generate two pandas dataframe that would take the format you’d like (each with a different “Totals” column, but same index), and merge them. Then, render the result with something like DataTable. This approach will likely not be able to directly incorporate dash-pivottable though.