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
LVL 1
agwalshAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ejgil HedegaardCommented:
I don't think that is possible.
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
agwalshAuthor Commented:
Actually I found that if I used the GETPIVOTDATA function, that did the trick for me. Please see attached file for example... :-) But thank you for your help :-)
EE---pivot-table-percentage-example.xlsx

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Martin LissOlder than dirtCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.