Perhaps you can add a helper column to the main data with formula like:

=IF(F2="",0,F2)

Where F2 is first Content_Completed column entry. Copy formula down. Put a header title in the column and use that column in the Pivot table instead.