I made a qvw with sample data in order to show you the problem I have. I have to obtain the sales value in a table chart based on a dimension isolated from the facts table. It is the orange object.
Could anyone help me with the expressions, please? I appreciate any help.
Since your two tables are not associated you will be calculating with a cartesian product in any expression that uses fields from both tables. You won't get any sensible results. What is the result you are expecting?
In my complete model I can not link these tables, and I can not make this field Distinct. I need to obtain the value using the dimension in the other table (which has the same possible values).
If it is not possible, I will try another way. Just tell me.