I apologize at the outset for just taking a surface stab at it,
but please see if the attached could be a first step.
I was able to calculate sums on prior8 and following8 and
get them two window sum between the sources.
One major problem is that I made the assumption that each
Customer has only one engagement date.
If that is not the case, will revisit.
Also, not crazy about the dual axis bars, one on top of the other,
having to use the width to differentiate. Also will be problematic
if Customers are on the Row shelf. I probably didn't catch your
vision for the graph, maybe if you could post a mockup desired
IF ATTR([Order Date])<DATEADD('week',8,ATTR([Sheet1 (210749stampA)].[Timestamp]))
AND ATTR([Order Date])>=ATTR([Sheet1 (210749stampA)].[Timestamp])
IF FIRST()=0 THEN
210749rev.twbx 23.4 KB