Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Percentage Calculation
I have the following data:
Branch ShipmentID Invoiced by 15th Invoiced COR 123456 0 COR 234567 234567 1 There are over 7,000 rows containing data like this. By a VLOOKUP formula, if a shipment is not invoiced, the "Invoiced by 15th" cell will be blank, and by formula the "Invoiced" column will return a zero. So, for example, out of all the rows, I may come up with Branch COR having 425 invoiced shipments out of a total of 445 shipments. I cannot figure out how to get the pivot table to give me the percentage of invoiced shipments (in this case would be 96%). Any ideas? Please? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Percentage of Sub-Total | Excel Worksheet Functions | |||
Need running percentage in pivot table | Excel Discussion (Misc queries) | |||
How to add a percentage column in a Pivot Table | Excel Discussion (Misc queries) | |||
Percentage calculation in pivot table | Excel Worksheet Functions | |||
Displaying percentage in ranges in pivot table | Excel Worksheet Functions |