Counting Occurence of identical order numbers

X

ximenez47

I have exported some information from our system that contains Purchase Order
detail. What I need to do is count the number of PO's and not PO lines, the
infor contains a PO reference for each line, and then link the responser to
the originator. This is so I can report on the number of PO raised by
particular a particular person. I can do this with the lines no problem just
can get the info by PO.

I have tried subtotal but this does not seem to work properly, and filtering.

any ideas.

pse
 
X

ximenez47

Thanks

I have all this data in Pivot tables but just can not get it total the
number of Purchase Orders rather than the number of PO Lines. There seeems
to be no way of calulating this that returns a sensible answer in the right
place

thanks
 
B

Bernard Liengme

Hard to solve without seeing the data. Maybe you need to use COUNT rather
than SUM
best wishes
 

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

How do I create a purchase order log in Excel? 1
Conditionally format last row of matching criteria 5
How do I lookup the number of unique values from a list? 0
auto numbers 1
match debits with credits 0
Match Debits and credits? 3
Subform causing duplicate records? 7
Code Check Request - Query to find reused values 2

Top