Hi
I have one table with sales order information and I have another with appointment information. The sales order information comes from a spreadsheet and the appointment from a sql server.
I have created a series of calculated fields and a pivot table output, but when I want to form a calculation between the two (conversion for example) I get a relationship error.
I think this may be because the salesman in each table is formatted differently, so I created a new table to link them via a unique ID.
I still get the relationship error when I try and analyse by salesman.
Any ideas?
I have one table with sales order information and I have another with appointment information. The sales order information comes from a spreadsheet and the appointment from a sql server.
I have created a series of calculated fields and a pivot table output, but when I want to form a calculation between the two (conversion for example) I get a relationship error.
I think this may be because the salesman in each table is formatted differently, so I created a new table to link them via a unique ID.
I still get the relationship error when I try and analyse by salesman.
Any ideas?
