Good to know, finally the workflow runs as desired.
Yes , that is possible. Any use of VCs over multiple rows could impact sync time. However in general reports are not supposed to be very long. I believe you may need to further optimize expressions so that VCs and reports run against smaller data in future.
<< Start: SORT((SELECT(Location Group [Item Id], TRUE))>>