locking column in pivot table without data

Here is an example datasheet. If you click on all sources in slicer datachart is fine, when you click on any one source, the "open" column disappears because it has no data in it
and then the chart goes wrong.test.xlsx