10 Replies Latest reply: Feb 27, 2013 5:49 PM by Giovanne Bergstein RSS

    Set Analysis to present data from the previous month when the filtered dimension this year as the current selection

      Hello I have the following situation:

       

       

      used the following set Analysis:

       

       

      sum ({$} <Month_Sale = {$(=month(addmonths(max(Date_Sale), -1)))}> Qty)

       

       

      By using the expression above it works correctly when the selection year is exergar filter to the data of the previous month, my problem happens when I select the month of January because this expression brings zeroed data, how can I resolve this situation? thank you