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

    Giovanne Bergstein

      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