SAP BO WebI Cross table with one value on different dates

[Hermart]

Hello experts,

I have two queries, my dimensions are date, customer_id, group.
Each customer can switch between groups over time, so at date 1.1.2024 he is group A and 1.6.2024 he is group C.
So I have one query selecting the first date, and the other one is selecting the other. 

Now, I want to show this changing in a table, with all customers counted and how they changed over time, basically with an output like this:

This table shows that we had 50 customers in group A at both dates at the same time, from these 50 customers, 13 moved into group B at 01.06.2024 and so on.

My result always looks like this, I cant get the numbers to show on the whole table.

Hope you can help me.

Best regards

[Hermart]

Pushing this up

[Hermart]

Anyone?