Forum Discussion
Helper IRelationship ambiguity
Good day
Please assist, I am trying to create a realtionship between my customer price list and stock master report, but i am getting the ambiquity error please see screen shots below
Try changing the cross filter direction to single, so that Stock Master filters customer price. You also want the relationship from customer master to customer price to be single direction, so that customer master filters customer price.
6 Replies
johnt75Super User
Both of those tables already filter ItemWiseSales so you can't have an additional relationship between the two.
- TaariqHussain
Itemwise sales is filtered by Stock master and customer master
I want the Customer price list to be filtered by the same data - stock master and customer master
what i am trying to achieve is a comparison between my selling price and price lists to make sure goods are sold according to price list - is there another way around this
The price list is also customer dependent thats why i need the relationship between customer price list and customer data
Customer price list sample
- johnt75
Delete the relationship between customer price list and sales then create a relationship from customer master to customer price list and from stock master to customer price list.
Create a table visual with columns from the customer master and stock master tables and they will both filter both sales and customer price list, so if you define measures to get the relevant prices from both sales and customer price list you can do a comparison for each product-customer combination.
- TaariqHussain
Thank you, that worked