Pivot - % of total

nelsok

Board Regular
Joined
Jan 20, 2006
Messages
166
In a pivot table....in field properties .... options ..... show data as and select % of...

I would like to know what each records % of the total is, I do not see this as an option.

Am i missing something or is there another way to accomplish this?


thanks.
 

Some videos you may like

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

yee388

Well-known Member
Joined
Mar 7, 2004
Messages
1,374
I'm using XL2003, and I got this screen when I went into field settings:

 

Watch MrExcel Video

Forum statistics

Threads
1,112,796
Messages
5,542,552
Members
410,560
Latest member
1ndependent
Top