I am using the following nested expression in set analysis to dynamically select a date period :
Max({<Transaction={'Last Known Stock Qty'}, Ledger={Actuals}>} Date)
Here is the full expression which I would like to return a bespoke date range for each dimension value:
Sum({<Transaction={Bill}, Ledger={Actuals}, Date={">$(=Max({<Transaction={'Last Known Stock Qty'}, Ledger={Actuals}>} Date)) <=$(=Max({<Transaction={Channel}, Ledger={Actuals}>} Date))"}>} [Billed Qty])
The expression delivers the correct date when used on its own and honours the dimensions, however when it is nested it seems to ignore the dimensions and returns the global Max() date.
Is this normal behaviour? If it is, how do I get the nested expression to honour the dimension values.
