Thanks for your reply... But unfortunately it doesn't solve the problem.
As I said before my problem is that, currently, the second dimension only shows NULL values, and so the supress null values option in the dimension tab is already unchecked (If not, it would supress everything).
In my understanding, the second dimension expression is being influenced by the set of values available in the first dimension. I mean:
- The first dimension expression queries for: Warehouses registers with Warehousetype= 'Destination', and so, the result is: Warehouse=A with ID_Warehouse=D01, and Warehouse=B with ID_Warehouse=D02
- The second dimension queries for: Warehouse registers with Warehousetype='Source' in the set that results from the first dimension, and so shows Null.
Does anyone knows if there is a way to calculated the second dimension disregarding the first dimension?