Pivot table: total rows
YBA_1917
Posted messages
3
Status
Member
-
ALS35 Posted messages 1034 Registration date Status Member Last intervention -
ALS35 Posted messages 1034 Registration date Status Member Last intervention -
Hello,
Excel 2016. I'm creating a pivot table from a very simple data table. I want a total for each column and a total for each row. I go to right-click -> pivot table options -> totals and filters -> I check "show row totals" and "show column totals". A row is added at the bottom of my table to display the column totals -> OK. No column appears to the right of my table to show the total for each of the rows. I would also like a grand total at the bottom right of the table, where the column totalization row (which is there) intersects with the row totalization column (which refuses to display). What's going on? What's wrong? Thank you for your help.
Excel 2016. I'm creating a pivot table from a very simple data table. I want a total for each column and a total for each row. I go to right-click -> pivot table options -> totals and filters -> I check "show row totals" and "show column totals". A row is added at the bottom of my table to display the column totals -> OK. No column appears to the right of my table to show the total for each of the rows. I would also like a grand total at the bottom right of the table, where the column totalization row (which is there) intersects with the row totalization column (which refuses to display). What's going on? What's wrong? Thank you for your help.