because the data table is ever increasing, I made the table A2:M2500
My pivot table is designed to show only the incomplete items "blank" in the Completed Date column.
Problem is it shows the dozen or so incomplete tasks properly and then says there are 560 (blank) ie the entire row is blank
can you force the Pivot Table to only look at the rows in the data table that are not blank?
Bookmarks