It seems that you want to get sold product count of each month, right? If so, could you please share sample data of the three tables? We need to know that if there are duplicated values in “month of the sales” column and product id column in Table 3 and what field you use to create relationship between Table 2 and Table 3.
Thanks, Lydia Zhang
Community Support Team _ Lydia Zhang If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.