Pivot Table Percentage Calculation

T

Teri

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?
 

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

Multi level groupby clause is not allowed in a subquery 3
Pivot Table Counting Text Data 0
Get information to a form from another table 21
Excel 2007 vlookup with Pivot table 0
Formula to Look up values from a pivot table 1
Average of % in pivot table 1
Splitting a table 3
Calculation referring to Pivot Table 0

Top