Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
in my model i have an expression which is working well in a straight table ,
within the straight table, when user select Apr-18 in the calendar the expression will retrieve the sum of all Sales below the max date (04/30/2018).
i want to use this kind of expression with month dimension (chart or a table) , but it is not working as i need the accumulated sum per each month.
sum({$<ValueDate=,YearMonth=, Year=,Month=,Group={50,51},Date= {"<=$(vPossibleDates)"} > } Sales)
vPossibleDates = date(max(ValueDate))
any ideas ?
advanced thanks
AsOf Calendar table is usually very helpful for accumulation. Please refer following link