Currently the "Analysis > Totals > Total All Using" applies to both Row and Column Grand Totals.

I want to be able to specify a separation aggregation for Row and Column. For example, I want:

1. Analysis > Totals > Total All Rows Using
2. Analysis > Totals > Total All Columns Using

Will need to flush out the design first.

• Need to investigate the amount of effort required to add the support in the Pivot model.
• We will probably replace the the "Total All Using" with the separate Total All Rows Using and Total All Columns Using.
  • Will need to do the same for the measure field right-click menu.
  • Will probably need to disable/enable one or both depending on whether Grand Total and/or Sub Total are enabled for Rows or/and Columns.
  • Should probably keep the other aggregation in sync when only Row or Column total is enabled. For example, if I show only Row grand total, then when I change the Show All Rows Using, the same change will be done for Show All Columns Using so that when I enable Show Column Grand Totals, it will start off using the same aggregation.
• We will need to consider backwards/forwards compatibility. For example if I save a workbook with different aggregation for Row and Column, which aggregation is used when I open this workbook in a previous version of VA?