Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to select year and month, for example year=2017 and month=January.
And in the advanced expression, to show data since January 2016 to January 2017.
Currently my expression is:
COUNT(distinct {<[Año_Emision_Poliza]={">=$(=Max(Año)-1)<=$(=Max(Año))"}>}Cod_Contratante)
But It does not work when I select the month
Please help me!!!!!!!!!!
Something like this should work
=COUNT(distinct {<[DateField]={">=$(=MonthStart(AddMonths(Max([DateField]),-12)))<=$(=MonthEnd(Max([DateField])))"},[Month]=>}Cod_Contratante)
Try this
COUNT(distinct {<[Año_Emision_Poliza]={">=$(=Max(Año)-1)<=$(=Max(Año))"},Month=>}Cod_Contratante)
Hi,
I want select month, no eliminate Month
If you want to select month and get values!
COUNT(distinct {<[Año_Emision_Poliza]={">=$(=Max(Año)-1)<=$(=Max(Año))"}>}Cod_Contratante)
Can you please tell me, What do yo mean by the above expression of yours not working??
This expresion is correct but I want since January 2016 to January 2017 or since February 2016 to February 2017,
since March 2016 to March 2017.
Depend of my selection of Month and Year.
if I select January 2017, in my expression I need to show data since January 2016 to January 2017
Something like this should work
=COUNT(distinct {<[DateField]={">=$(=MonthStart(AddMonths(Max([DateField]),-12)))<=$(=MonthEnd(Max([DateField])))"},[Month]=>}Cod_Contratante)