Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-23-2013, 01:14 PM
New Daddy New Daddy is offline Can you add percentage (%) columns to a pivot table? Windows Vista Can you add percentage (%) columns to a pivot table? Office 2003
Advanced Beginner
Can you add percentage (%) columns to a pivot table?
 
Join Date: Jan 2012
Posts: 90
New Daddy is on a distinguished road
Question Can you add percentage (%) columns to a pivot table?

I've done a fair amount of Google search and decided that there is no easy way to pull this off. But I wanted to see if people have really good tricks.

Is there an easy way to add percentage columns to a pivot table? What I want to see is the proportion of each column as percentage of the total that appears in the last column. We see this all the time in scientific data, but I'm curious that Excel provides no automatic way of doing this.
Reply With Quote
  #2  
Old 11-23-2013, 02:06 PM
New Daddy New Daddy is offline Can you add percentage (%) columns to a pivot table? Windows Vista Can you add percentage (%) columns to a pivot table? Office 2003
Advanced Beginner
Can you add percentage (%) columns to a pivot table?
 
Join Date: Jan 2012
Posts: 90
New Daddy is on a distinguished road
Default

I will add that I use Excel 2003. I've looked through some tutorial videos on Youtube, and some teach you how to add percentage columns to the pivot table easily by using "calculated fields", but it looks like the percentage of row/column total was introduced only in Excel 2007.

So any trick in Excel 2003?
Reply With Quote
  #3  
Old 11-23-2013, 09:49 PM
New Daddy New Daddy is offline Can you add percentage (%) columns to a pivot table? Windows Vista Can you add percentage (%) columns to a pivot table? Office 2003
Advanced Beginner
Can you add percentage (%) columns to a pivot table?
 
Join Date: Jan 2012
Posts: 90
New Daddy is on a distinguished road
Default

I've decided that there is really no easy way to do this in Excel 2003.
I've since upgraded to Excel 2007 specifically to do this. All is fine in Excel 2007.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Can you add percentage (%) columns to a pivot table? How to total 12 columns and divide them to get a percentage Triscia Word Tables 1 01-15-2013 07:39 AM
Pivot Table uhlersa Excel 0 10-15-2012 12:01 PM
Pivot table help TishyMouse Excel 2 04-27-2012 10:19 AM
Can you add percentage (%) columns to a pivot table? Help with a pivot table please! natsha Excel 1 02-16-2012 12:41 PM
percentage on columns 911 Excel 1 09-01-2010 09:28 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:37 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft