Forum Discussion

derekli1700's avatar
derekli1700
Helper III
1 year ago
Solved

Matrix 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...
  • parry2k's avatar
    1 year ago

    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.