3 Replies Latest reply: May 24, 2018 12:18 PM by Jorge Sanchez RSS

    Filtering within Quarter table set analysis

    Jorge Sanchez

      Hi,

       

      I have this table

      tabla.PNG

      Dimension "trimestre" are quarters with this formula: =[fecha.autoCalendar.YearQuarter]

       

      Measures "Nuevos" and "Resueltos" are SUM functions of the values among the three months in that quarter.

       

      My raw data have this format:

      IDfechaValor
      101/12/20171
      101/01/20182
      201/01/20184

       

       

       

      My problem comes at the last measure "Stock". In this case I want a SUM function just with the values belonging to the last month of that quarter.

      I tried the following but it only works for the last quarter (as you can see in the table):

      Stock --> =Sum({<fecha={"$(=max([fecha]))"}>}valor)

      I want the last "fecha" (date) of that very quarter, not the absolut one.

       

      Thanks in advance.