Step By Step:
First Step Pivot your data and Recreate the View. Your view is Complex so I would prefer you to create the view using Pivoted data and then we can move forward
I would have pivot my data if I didn't have other constraints. My org limitation is to keep the data in the current format.
Is there still any workaround using this approach/data set?