Forum Discussion
derekli1700
Helper III
Helper IIIMatrix Table help
Hi everyone, I have a problem where i have a data sheet of 3 main tabs: 1. Top 20 stores and their volume each month 2. The top 5 customers each of those 20 stores and how they have contributed...
derekli1700 I wouldn't recommend this approach because it is not the best practice but you can try to add a new column by concatenating the period and the store column in both Overview and Top 5 monthly tables, and then use this column to set the relationship, and I believe it will get you the correct numbers.
parry2k
Super User
Super Userderekli1700 I wouldn't recommend this approach because it is not the best practice but you can try to add a new column by concatenating the period and the store column in both Overview and Top 5 monthly tables, and then use this column to set the relationship, and I believe it will get you the correct numbers.