Add a Percent of Total Row Totals Option
When building a cross-tab report, if you set a Metric's Aggregation to Average, then the Column totals no longer make sense in terms of using a Percent of Total Advanced Function:
As you can see above, neither the Row or Column Totals are correct.
If you use SUM, it correctly calculates the Percent of Total at the column level, but it also SUM's the row values, which provides for undesired values:
Instead for the Row Totals column, it'd be nice to have an option for using Percent of Total there