8 Replies Latest reply: May 23, 2012 6:54 AM by askowronek RSS

    How to combine sum & monthsstart


      I'm the beginner and need your help.

      I would show in the one chart sales for current and previous months and don't know how to prepare script.

      (Sum({$}[Sales 1])) - I used that one for present selected month.

      What script should I use for presenting data tied with previous than selected month. I tried to use "MonthsStart(1,Period,-1)" but can not combine it with one above.