As per my observation because of the filter View Date Parameter match you are getting less records in your view/sheet as below:
you have a calculation field with calculation:
[Consumer Name Parameter]=[Source Sys Name]
In the parameter they are multiple values, but there is only one value i.e ICS matching with the values of Source Sys Name in the view so except for ICS for others the sheet will be blank.
Hope this will give some information. Please tell me for any more info.