16 Replies Latest reply: Oct 3, 2012 12:48 PM by haagenfels RSS

    show current and previous 2 months.

      Hi,

       

      I am trying to create a bar graph that shows the count(month) but does not show any data from two months prior to the current date. I have my dimension as Month and Expression as count(month).  That shows the graph with the correct numbers but i would like to only show the previous two month from the current date. I tried to create another expressions Sum({<Month={"$(=Max(Month)-2)"}>}[Month] but I think its wrong.

       

      Any help is appreciated.

       

      Thank you