What is the problem or goal the end user is trying to solve or accomplish?
When we have different types of metrics in 'Pivot Table' (for example, amount and ratio), and we want to aggregate them to create a row summary, we get strange results for one of them. For example, we might be summing a percentage ratio. I'm using row orientation for the metrics and the 'combine metrics' option.
How are they solving it currently?
There is no clear option. We could use the 'Table' visualisation with the option summary, which works correctly for different metrics but only for columnar summing, but there we can use row-oriented approach.
What is the recommended solution by the Customer?
Create a summary of the 'Table' row totals in the 'Pivot Table'.