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 and having multiple row groups and metrics (especially an average metrics). It adds all the average metric of the subgroups and uses it as the final value for the group value.

How are they solving it currently?

Not possible using interactive pivot table, might need to use the normal pivot table chart instead.

What is the recommended solution by the Customer?

Allow aggregation function on interactive pivot table chart similar to the option available on a normal pivot table chart. This would then do the calculation correctly for the average metric.