Set Analysis trouble

[Anonymous]

Hi all,

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.

Thanks.

[Anonymous]

OK. Let's say I have a model with all my sales data. My app works in this analysis. After that I was told to add in my objects a reference number related to budget. Due to the model I have I can not link this budget table to the data model. From here I have 2 options:

1. Use set analysis  to obtain it. The sample file attached shows it.

2. Calculate it in script and add a field somewhere in the model, avoiding isolated table in model.

Before doing option 2 I wanted to be sure about the first one.

Thanks for helping.

Marc.