Ability to enable/disable row/column calculations independently in pivot view
Currently the calculation based on cell values (e.g. sum, average, count, etc.) is enforced in both the row and column direction. This is not always desired. The column totals could make sense whereas the row calculation don't as the fields they r...
about 3 years ago
Pivot table - split option for Summary Row/Column
I have Pivot tables that need totals. However, 99% of the time, the Total only makes sense for either the columns or the rows. Having to include both shows a row or column that is irrelevant
over 2 years ago