Percentages in PivotTables

vb_crazy

New Member
Joined
Jan 28, 2005
Messages
19
Hi - Need help generating percentages for a PivotTable:

In column one, I have a count for each item, with the grand total at the bottom (Grand Total row generated by PivotTable)

I want to create a second column that divides each item count by the Grand Total to get the percent of the whole number.

I'd like to do this within the Pivot so that when I change the Page By feature, everything updates automatically (rather than creating the formulas outside of the Pivot, and having to copy percentage formulas down if the number of items increases)

thanks!!
 

Some videos you may like

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

Russ At Index

Well-known Member
Joined
Sep 23, 2002
Messages
670
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
  2. MacOS
Hi V_B Crazy,

Have a look at the "calculated fields" option within
your pivot.
It enables you to perform various tasks using the
data extracted into your table.

HTH

Russ.
 

vb_crazy

New Member
Joined
Jan 28, 2005
Messages
19
Actually, I already did that, and when I tried to refernce the Grand Total, Excel gives me an error message saying it doesn't accept References, Names or Arrays in formulas for calculated fields

any other ideas?
 

madsenj

New Member
Joined
Nov 7, 2003
Messages
1
percent of column

you probably already figured it out but...
in wizard, layout, select the count field again and then double click on it. select options change the show data as to % of column. hope that works for you.
 

vb_crazy

New Member
Joined
Jan 28, 2005
Messages
19
Actually, I didn't - I had to find a workaround on my own.

But, this works MUCH better!! Thanks a lot!
 

Watch MrExcel Video

Forum statistics

Threads
1,118,017
Messages
5,569,640
Members
412,284
Latest member
Daibear
Top