Forum Discussion
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
- amitchandakSuper User
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
- AnonymousNot applicable
Hi. I join these dimensions but it still doesn't work with filters.