% 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

% 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

% of fixed sum in pivot table
 

Add a Calculated Field:
http://www.freefilehosting.net/download/3beig