I’m creating an Excel sheet for complaints, each new complaint goes in a new row. I want to count how many times each complaint was answered compared to its deadline. I have a column which adds on the correct timescale to when the complaint was first received to get the deadline. Another column compares the […]

Categories

## Excel pivot table filter when data is missing

- Post author By How To
- Post date May 27, 2020
- No Comments on Excel pivot table filter when data is missing

- Tags "No"), and Ongoing compared to each workplace section. I then use a formula to copy the data from the Pivot Table into a 'Performance' tab to make i, and Ongoing if there is a date received but no completed date filled in. I created some Pivot Tables to count each Yes, but when I delete the dummy data the filter goes too, each new complaint goes in a new row. I want to count how many times each complaint was answered compared to its deadline. I have a column wh, I'm creating an Excel sheet for complaints, its just counting all of them. It counts the 3 Yes complaints received, No if its overdue, so instead of counting the number of No responses, which I've already counted in another column in my performance tab. Basically my question is - is there a way to specify the Pivot Table to