Excel Pivot Table, calculate count of column fields as percentage of total

1

Excel Pivot Table, is there any way to create a column that calculates the number of times a value shows up in a specific column relative to the total number of fields in that column as a percentage of the total?

H S

Posted 2019-10-31T13:51:37.920

Reputation: 11

1Might want to give a screenshot or sample of your data & expected results. You'll have to make expected results manually until you get a response if Excel can do this. Hopefully you aren't trying to get someone to do your homework? – gregg – 2019-10-31T14:23:50.863

Is this relevant for you only for pivot tables? Or do you want to know how to do this also in ordinary tables? – Christian Geiselmann – 2019-10-31T14:44:15.890

No answers