Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
% of fixed sum in pivot table
I need a pivot table which will show me the following results (see the table
below) I have managed to get TOTAL REV and # OF CASES, but I can't get % OF REV to run correctly. The formula for the column % OF REV I want is (9160/10000=92%) Month Data ------- ------ Jan Feb ------------------------------------- -------------------------------------- Analyst Total rev % of rev # of cases Total rev % of rev # of cases -------- ---------- --------- ------------ --------- ---------- ------------ Amy 9160 92% 9 Bob 13562.5 136% 6 Candice 10790 108% 10 Debbie 7825 78% 7 Emilie 8705 87% 10 Florence 13235 132% 8 Grace 4450 45% 1 Please help. Thanks, Karen |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
% of fixed sum in pivot table
Hi Karen
Can you post a sample of what your data looks like -- Regards Roger Govier "Karen" wrote in message ... I need a pivot table which will show me the following results (see the table below) I have managed to get TOTAL REV and # OF CASES, but I can't get % OF REV to run correctly. The formula for the column % OF REV I want is (9160/10000=92%) Month Data ------- ------ Jan Feb ------------------------------------- -------------------------------------- Analyst Total rev % of rev # of cases Total rev % of rev # of cases -------- ---------- --------- ------------ --------- ---------- ------------ Amy 9160 92% 9 Bob 13562.5 136% 6 Candice 10790 108% 10 Debbie 7825 78% 7 Emilie 8705 87% 10 Florence 13235 132% 8 Grace 4450 45% 1 Please help. Thanks, Karen |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
% of fixed sum in pivot table
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
Pivot Table Column Widths will not stay fixed... | Excel Discussion (Misc queries) | |||
Define and Reference fixed data in a table | New Users to Excel | |||
help! how do i create a table with fixed headings?? | Excel Discussion (Misc queries) | |||
How can I add a fixed value to all cells in a table? | Excel Worksheet Functions |