Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello -
I am struggling with writing an expression that would display current month (as a default selection) and then the formula would need also subtract 13 month.
My Dimensions are:
Please help!
Thank you
Hi,
you'll have to adapt to your dimensions but it could be something like this:
sum({$<MonthYear = {'$(=Monthname(today(), -13))'}>}Sales)
besides you'll need to ignore in set analysis any time field that could interfere in the calculation (specially if these fields are visible to end users) like: date=, month=, year=, week=, quarter= and so on
regards
=SUM({<MonthYear = {">=$(=Date(AddMonths(Date#(Max(MonthYear),'YYYY-MM'),-13),'YYYY-MM'))<=$(=Date#(Max(MonthYear),'YYYY-MM'))"}>}Sales)