Allow aggregation function on interactive pivot table chart similar to a normal pivot table chart

What is the problem or goal the end user is trying to solve or accomplish?

Currently when using a interactive pivot table or the pivot table and having multiple row groups and metrics (especially an average metrics or metrics that produces percentages). It adds all the average or percentage metrics of the subgroups and uses it as the final value for the group value instead of re-calculating the metric total.

How are they solving it currently?

Not possible using interactive pivot table or the pivot table, use normal table or interactive table.

What is the recommended solution by the Customer?

Provide the aggregation option based on metric total on interactive pivot table and pivot table charts similar to the option available on an interactive table. This would then do the calculation correctly for the average metric or percentage metrics