Percentage of Total Pivot

[mtnbiker98]

Hello,

First, thank you to the community for being here and for your help.

I could use a bit of help with a Pivot table.

I have groups of users...let's call them A, B and C. I am migrating them to a new computing solution.

I would like to show in a pivot those that have been migrated as a total of all users in that group (A, B, C).

I am not an expert at pivots but, i've set up a table with all the groups and applied a filter for all that have been provided with a new solution. But, how do I relate that to the total user population in that group? Seems like a filter may not be the way to go.

Any thoughts?

Thank you!

[Richard Buttrey]

Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

[sandy666]

you can try with

percentofgrandtotal.jpg

or as Richard said: example Excel file