Problem with pivoting when cells have missing values

I am a fairly new BI user and have been tasked with running/ upkeeping a pretty complex BI dashboard that was built by someone else.  As I was refreshing the dashboard, I received an error which seem...