ExcelBanter - How do I generate and subtotal percentages of data in a pivot tabl

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I generate and subtotal percentages of data in a pivot tabl (https://www.excelbanter.com/excel-discussion-misc-queries/77300-how-do-i-generate-subtotal-percentages-data-pivot-tabl.html)

Stan Sitek

How do I generate and subtotal percentages of data in a pivot tabl

steven1001

How do I generate and subtotal percentages of data in a pivot tabl

You could try using the function on the Field which lets you display as
a %.
Right click on the value, select Field Settings, Options, Show Data
As.
Then you get a range of choices.
Regards..

--
steven1001
------------------------------------------------------------------------
steven1001's Profile: http://www.excelforum.com/member.php...o&userid=30757
View this thread: http://www.excelforum.com/showthread...hreadid=522445

All times are GMT +1. The time now is 08:28 PM.