% of fixed sum in pivot table

K

Karen

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
 

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 columns 3
PIVOT TABLE SUM OF AVERAGES 1
Average of % in pivot table 1
Average of Subtotals in Pivot Table 0
How do I perform extended calculations in a Pivot Table in Excel 2 4
interesting pivot table questing 1
Pivot table calculated field Count(field) / sum(field) 0
Calculated Item in a Pivot Table 2

Top