6 Replies Latest reply: Nov 8, 2010 6:20 PM by moshea444 RSS

    Sum up to a selected month, even if only one month is selected (aka YTD)

      If a user selects Nov then one column on a table shows the MTD for Nov. This works fine, however, I also want to add another column that shows YTD for Nov. I can get the right value if the user selects Jan-Nov but i want it to work if they only have Nov selected. I think this can be done with set analysis but im not sure. Here's what i've been trying:


      {$<SaleMonth={'<only(Month)'} >}