2 Replies Latest reply: Mar 23, 2016 4:22 AM by Hasvine Dhurmea RSS

    Dynamic filter

    Hasvine Dhurmea

      Hello All,

       

      Attached you will find a sample.

       

      I have 'DATE FACTURATION' in my data source which i converted into 'Mois_enquete_calcul' to get the Month&Year.

       

      AND my expression is:

       

      =Count({<Mois_enquete_calcul={'>=$(=Max(Mois_enquete_calcul)-3)<=$(=Max(Mois_enquete_calcul))'},Q11={'OUI'}, MAKE={'CITROEN'}>}Q11)

       

      Actually what I need is that when I choose on nov.-2015 in my 'Mois_enquete_calcul' selector I get only the month of nov.-2015, oct.-2015, sept.-2015 and aug.-2015.

       

      Right now, when I choose a given month it shows all the months before the month I chose.(like it does not stop at the month -3)

       

      Any one has an idea how I can perform that please.

       

      I tried many ways but I am stuck.

       

      Thanks,

       

      Hasvine