Can you show me the steps or possibly share the twbx file?
I was able to get that without a join though, but involved multiple calculations
There is an attachment go to my reply in your main thread, not in email
you need to create a separate table of all your values of like A,B,C etc
Create a cartesian join using 1:1
filter using the Calculaton I provided in workbook