Pivot table from CSV data, problem getting a percentage from the total

G

Gloria Thrurk

Hi,

(P.S. This is more readable with Courier font.)

I'm using data from a CSV file to make a Pivot Table.
My data is sum of widgets per year.

In the Pivot Table, I have the years across the top as column headers
so it looks like this :

2000 2001 2002 2003 2004 2005 2006
A 437 179 431 203 14 321 270
B 267 382 429 432 205 257 176
----------------------------------------------------------------------
Now in a standard pivot table I can get a total on each line:

2000 2001 2002 2003 2004 2005 2006 Total
A 437 179 431 203 14 321 270 1855
B 267 382 429 432 205 257 176 2148
----------------------------------------------------------------------
But what I really want is this:

2000 2001 2002 2003 2004 2005 2006
A 24% 10% 23% 11% 1% 17% 15%
B 12% 18% 20% 20% 10% 12% 8%

where each data cell is expressed as a percentage of the total,
but I don't have the total in the CSV file.
----------------------------------------------------------------------

Any ideas?
Thanks in advance.

Gloria
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table from CSV data, problem with percentage of total. 1
How to add a percentage column in a Pivot Table 1
Access pivot table question 2
Filtering credits in a Pivot Table 3
Pivot table question: How to display total and percent for data simultaneouly 1
display data as a percentage of a subtotal in excel pivot table 2
How to extract a character from a string then VLOOKUP a table? 7
Pivot table sorting, should be easy I think 1

Top