Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot table from CSV data, problem with percentage of total.
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot table from CSV data, problem with percentage of total.
You have one response at your other post.
Gloria Thrurk wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Data - Troubleshoot needed | Excel Discussion (Misc queries) | |||
Pivot Table external XLS file source change and GETPIVOTDATA refresh | Excel Discussion (Misc queries) | |||
Pivot table question: How to display total and percent for data simultaneouly | Excel Discussion (Misc queries) | |||
Subtotals in a Pivot Table | Excel Discussion (Misc queries) | |||
Pivot Table - Data Source problem | Excel Worksheet Functions |