I am totally stumbled on this. Consider these data:
events:
LOAD * INLINE
[
atid,club,map
AT1,FIRME,DT1
AT2,FIRMA,NULL()
];
transactions:
LOAD * INLINE
[
map,brand,value
DT1,FIRME,100
DT1,FIRMC,200
DT2,FIRME,400
];
The key here is that the club of the events and the brand of the transactions are containing the same kind of values.
I want to make a table chart that has (event) club as dimension, and create a measure that will sum the value of transactions the have [brand] equal to the chart's [club] dimension, even if they are NOT connected with any event of such club, or any other. In my test data, for club FIRME I want the sum(value) to be 500, even if DT2 is not connected to any event.
I have tried many things.
sum({<[brand]=p([club])>} value) will not return unconnected transactions
sum({<[brand]=p([club]),[club]=>} value) does the same
Could anyone shed some insight?