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

    show current and previous 2 months.



      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