Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Custom formula to show each item as percentage of grand total?
Have a PT like this:
Month Who Jan 3.5 Feb 2.2 Mar 3.3 Total 9.0 I want to add a new custom field or whatever on the right of this that will show each item as a percentage of the total so I see 2.2 and 25% next to it. Thanks Rory |
#2
|
|||
|
|||
try this. copy down
=G1/SUM($G$1:$G$4) -- Don Guillett SalesAid Software "RoryMacLeod" wrote in message ... Have a PT like this: Month Who Jan 3.5 Feb 2.2 Mar 3.3 Total 9.0 I want to add a new custom field or whatever on the right of this that will show each item as a percentage of the total so I see 2.2 and 25% next to it. Thanks Rory |
#3
|
|||
|
|||
Hi Don, thanks for the response. I should have made it clear that this data
is in a pivot table and I want to use the Custom Forumla feature to generate the percentage field automatically. Rory "RoryMacLeod" wrote: Have a PT like this: Month Who Jan 3.5 Feb 2.2 Mar 3.3 Total 9.0 I want to add a new custom field or whatever on the right of this that will show each item as a percentage of the total so I see 2.2 and 25% next to it. Thanks Rory |
#4
|
|||
|
|||
Rory -
When making your pivot table, you have some kind of Sum of Value field which produces the numbers in the column. Drag the Value field into the data area again, to make another Sum of Value field. When adding the field, click on the Options button, and under Show Data As, select % of Total. Then drag the Data field button over to the top of the columns area of the pivot table. Here's how it looks with some data I made up: Data date Sum of value Sum of value2 Jan 22 32.84% Feb 13 19.40% Mar 21 31.34% Apr 11 16.42% - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ RoryMacLeod wrote: Hi Don, thanks for the response. I should have made it clear that this data is in a pivot table and I want to use the Custom Forumla feature to generate the percentage field automatically. Rory "RoryMacLeod" wrote: Have a PT like this: Month Who Jan 3.5 Feb 2.2 Mar 3.3 Total 9.0 I want to add a new custom field or whatever on the right of this that will show each item as a percentage of the total so I see 2.2 and 25% next to it. Thanks Rory |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to calculate a percentage formula with existing data? | Excel Worksheet Functions | |||
I want the results of a formula to show in cell, NOT THE FORMULA! | Excel Discussion (Misc queries) | |||
Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
Why does the formula result show a number but the screen shows ze. | Excel Worksheet Functions |