Currently with a Pivot chart you can choose to include a Total row AND column. For many pivot charts, only one of these makes sense and the other is useless space wasting data.
Found another reason this is necessary - I can only sort the pivot rows by the cell calculation if a total is included. So I have to include the summary row/column so I can then sort the entire pivot table by the cell calculation.
I am using a pivot table to include two similar but unrelated data points so having a row summary creates confusion. I do want the column summary though.
I would think this is an easy one to add, and would make pivot reports way more useful for me. For example, right now I have a pivot report with 2 columns, one of which is a feature count, and the second of which is a subset of that feature count where a certain field is populated. I very much want the column totals (which show me the total number of features regardless of that field's value), as well as the total number of features where that field is populated, but the row totals are meaningless.
Found another reason this is necessary - I can only sort the pivot rows by the cell calculation if a total is included. So I have to include the summary row/column so I can then sort the entire pivot table by the cell calculation.
I am using a pivot table to include two similar but unrelated data points so having a row summary creates confusion. I do want the column summary though.
I would think this is an easy one to add, and would make pivot reports way more useful for me. For example, right now I have a pivot report with 2 columns, one of which is a feature count, and the second of which is a subset of that feature count where a certain field is populated. I very much want the column totals (which show me the total number of features regardless of that field's value), as well as the total number of features where that field is populated, but the row totals are meaningless.