Forum Discussion
Helper IIFiltering Vendor Receipts from Selected Customer Sales
Hi, it's me again,
I'm still trying to filter receipt values based on selected customer sales.
My model has 2 fact tables (billing transactions + receipt transactions).
I would like to select in my table the customer in order to get all sales customers and based on the selected items the
vendors who has delivered the items.
Report with tables no selection
Customer Name 1 selected
Has someone an idea how I can filter the selected value in the Vendor Receipts table ?
My model I attached to this post.
Thanks a lot for your help and patients.
https://fileshare.ssl.iscar.com/data/public/79bbab - Click Here!
2 Replies
NickolajJessenSolution Sage
It's a bit odd to have customers and vendors in the same DIM table. Is there a special reason for this?
In can be solved in a few different ways.
The solution here creates a list of the product in the current selection and filters your Total sales Value based on the selection:
https://drive.google.com/drive/folders/1AjePk7NUXAloXHr42BEa2lDOr5dQr2Wg
AnSchmiDear NickolajJessen,
thanks a lot for your reply, I'm very much appreciating your feedback.
I have pulled the data from DB2 where customers and vendors are stored in one file. Further transactions are organized in one file as well (Orders, Billing, Receipts, etc.)
I understand now that it is a mistake not to seperate the records. I will change the model accordingly.I have a last question regarding your solution creating a list.
When I adopt this solution to a model with several hundred thousand of records, do I get a performance problem ?
If yes, is there an alternative solution summarizing the selected billing items to a variable to be filtered afterwards to get the receipt value ? better performance ?
Thanks a lot for your help in advance.