6 Replies Latest reply on Oct 15, 2018 6:34 AM by maneesh.gaddam

    rolling month sum with selected month

    Jessica Tung

      Hi I am creating rolling month calculation based on this video:


      Latest N Months


        DATETRUNC('month',[Order Date]),

        {MAX(DATETRUNC('month',[Order Date]))}) < [How many months?]


      I want to "travel back in time" by selecting one random month from the filter, and the chart shows the previous N months.

      Now if I make a month selection, the chart show only the selected month.


      Any suggestion is appreciated, thanks!