7 Replies Latest reply: Nov 13, 2017 8:57 AM by Daniel Rodríguez RSS

    Set analysis not working - Ignore selections

    Daniel Rodríguez

      Hello all

       

      First of all,thank you for your time. I really appreciate it.

       

      I have an issue with set analysis and I'm not able to solve it. The problem is the following:

       

      As you can see in this thread ( Working with dates - Last date ), I want to display just the last date data. With some help I was able to do it. The problem is that I want to ignore any filter I have and it seems that it's not working just with year and month. The formula I'm using is:

       

      sum({1<[date_variable] = {'$(maxdate)'}>}[A])

       

      where maxdate is: max(date([date_variable]))

       

      I don't see where is the problem as I'm using 1 to ignore all the selections...Is there anyone who can help me?

       

      Thanks so much