How to write script in the backend

[BI_Rockstar_265]

Hi Team,

I have table A having no of days column at each row(that means having duplicates) and

I have table B having no of days wise aggregation expressions (unique records)

Finally i want to make a relationship table B with Table A but it should not impact the results (whereas if i selected or filtered any records in table A  it should give correct results).

[PrashantSangle]

can you explain your query with some small dataset with expected solution.

Regards,

[BI_Rockstar_265]