View Single Post
 
Old 11-23-2013, 01:14 PM
New Daddy New Daddy is offline Windows Vista Office 2003
Advanced Beginner
 
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