1 Reply Latest reply: Aug 19, 2011 9:59 AM by javortiz RSS

    Month to date sum based on selected date

      Hi I am wanting to sum the total revenue we taken within a month, based on any selected date.

      I currently have use set analysis to sum mtd up until yesterday:

      sum({<[BudgetL1L2 Date]={">=$(=Monthstart(date(today()-1)))"}>} [Revenue Net])

      However i am stumped as to how i cam amned this to base it on any selected date.

      Does anyone have any ideas?

      Many thanks

      Kate