Hey hopefully someone can help me out I have a database each line is a different record. These records have date, company name, and then 8 fields with Accept reject or N/A. I am trying to create a pivot table that will show the count of each of the Reject totals (for each of the 8 fields) per company for each month. I am having a very hard time doing this. Ideally the company would be put into place as a filter for the entire table. The big issue i have is showing these totals of the 8 columns independentaly from the other columns. instead of (Reject, Accept, N/A, Accept, Accept, Accept, Reject, Accept) Thanks for any help at all.