Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this:
=Count({<Mois_enquete_calcul={">=$(=Date(AddMonths(Max(Mois_enquete_calcul), -3),'MMM-YYYY'))<=$(=Date(Max(Mois_enquete_calcul), 'MMM-YYYY'))"},Q11={'OUI'}, MAKE={'CITROEN'}>}Q11)
Try this:
=Count({<Mois_enquete_calcul={">=$(=Date(AddMonths(Max(Mois_enquete_calcul), -3),'MMM-YYYY'))<=$(=Date(Max(Mois_enquete_calcul), 'MMM-YYYY'))"},Q11={'OUI'}, MAKE={'CITROEN'}>}Q11)
Thanks Sunny.
It works.
KR,
Hasvine