I have a spreadsheet which shows audit results for bills, by customer name.
The bill could have multiple errors, with a different group causing the
error. I would like to show total bills reviewed, total # of errors for
those bills that are defective, and for those errors, each org. responsible
for error. How do I show this in a spreadsheet format where a PIVOT can be
created showing how many bills were defective, how many errors were on each
defective bill, and what org. has responsibility for that error? It is
almost like a one to many relationship. Need help on spreadsheet set up.
--
Pat Miller