Forum Discussion
Relationships
That is what I suspected. As you are doing basic table visual, it should be easy.
Can you create silo tables for Project No, customer name and then do the relationships?
Like star schema!
Sample:
Customer:
Project:
Cost:
Sales:
Model View:
Sample Table visual:
Thank you! I shall give that a go and let you know how I get on.
Thank you, that worked on my sample data however, when i imported all of my data, it errors.
Please see image attached.
I believe you must be using "Description" in relationships for one to many or vice versa. "Description" should NOT be part of any relationships.
Below are the relationship columns in my example:
- Customer: Customer Name ... Sales: Customer Name
Customer: Customer Name ... Cost: Customer Name - Project: Project No ... Sales: Project No
Project: Project No ... Cost: Project No
Also, make sure no duplicates in these two tables
~ Project: Project No
~ Customer: Customer NameHope it helps!
Thank you. I've tried that but still no luck.
I've done some playing around, not sure if this will help you identify what i'm doing wrong..If i it seems to "work" if i enter the 'Cost' as 'SUM of Cost' but i want it to show each products individual price, not the total. As soon as i click 'Don't Summarize' it errors.
The data in the visual table is as follows;
Project No - from Project Table
Customer - from Customer Table
Part No / Description / Sale Price - from Sales Table
Unit Cost - from Costs Table
- Customer: Customer Name ... Sales: Customer Name
