Idea Summary
Currently the Interactive Report Pivot Feature only shows column totals, I'd like to get row totals too.
Use Case
For example if you a report that showed sale transactions which included the customer name, category of purchase and amount purchased, you could create a pivot table to show the customer on each row, with a column for each category and the amount as the data point. Currently you could total the amounts by category (column) but you can't see the overall customer total, which would be the sum of the row amounts.
Preferred Solution (Optional)
Add an extra check box in the pivot wizard requesting to aggregate the row function and an aggregation selector. It should be optional, in some cases you may want the sum, in others the average etc so the different aggregation functions should be available, similar to the selection already available for the pivot column data already.