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:

      https://www.vizwiz.com/2017/03/latest-previous-prior.html#comment-form

      Latest N Months

      DATEDIFF('month',

        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!

       

      -Jessica