agwalsh
asked on
how to show percentage of column in pivot table for total column only
hi
Looking for a bit of help with this. I know how to show Values As % etc in the pivot table. But how can I do that JUST for the total column?
I've attached a file that shows what I get and also what I want...thanks.
Pivot-table-to-show-percent-breakdo.xlsx
Looking for a bit of help with this. I know how to show Values As % etc in the pivot table. But how can I do that JUST for the total column?
I've attached a file that shows what I get and also what I want...thanks.
Pivot-table-to-show-percent-breakdo.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
A pivot table is designed to show values for selected items and totals.
A possible solution is to hide not wanted columns and rows.
Percentage and value columns switched, to make categories visible.
The header Total for categories deleted.
Percentage columns, and rows 3 and 5 hidden.
Then it is almost as wanted.
But if new categories are added the percentage columns must be hidden manually, or made visible if categories are removed.
Update the pivot table to make the spelling correct.
If you copy the result, the hidden columns and rows are also copied, and must be deleted.
To use in a Word document I would copy as picture, and insert the picture in Word, then it looks exactly as in Excel.
Pivot-table-to-show-percent-break-1.xlsx