Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Creating relationship between Total Spend table and Concession Table

Hi everyone, 
I'm stuck on a report that has 2 tables. First is concession including Supplier name, Product group, date, claim amount, supplier agreed to credit. Second is Total Spend with Supplier name, Product group, date and total spend in USD. I need to make a column chart that works with filter by Product Group and Supplier name. 
Here is the model that I build but it doesn't work with both filters. I created 2 table Group and Supplier with distinct Group name and Supplier name and make those table as a brigde to Total spend table. 

Here is the Concession table 

 

Thanks in advance

2 Replies

  • Anonymous , why there is no join 1-m From the supplier /product group to both the tables? Both tables should join to these dimensions to show data together

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi. I join these dimensions but it still doesn't work with filters.