Configure the aggregation function independently for rows/columns on the Pivot Table Chart

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

Users have different columns on their Table Charts (some displaying total counts, and others displaying AVG), but unfortunately it's not possible to configure the aggregation function independently - all need to be sum or avg .

How are they solving it currently?

The only workaround would be to have different Table Charts - one for Totals, and other for AVG which is not ideal.

What is the recommended solution by the Customer?

Provide the ability to configure independent aggregation functions for each column/row on the Pivot Table Chart.