% of fixed sum in pivot table
- From: Karen <Karen@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Sun, 3 Feb 2008 23:14:00 -0800
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
.
- Follow-Ups:
- Re: % of fixed sum in pivot table
- From: Herbert Seidenberg
- Re: % of fixed sum in pivot table
- From: Roger Govier
- Re: % of fixed sum in pivot table
- Prev by Date: Re: newbe with a formula question.
- Next by Date: Re: Calculating Frequencies
- Previous by thread: Re: how do i reset the default from "general" to "number"
- Next by thread: Re: % of fixed sum in pivot table
- Index(es):