-
Re: To use results of a selection list in a chart
Mayil Vahanan Ramasamy Jun 13, 2012 11:47 AM (in response to Laurent ANKRI)Hi,
Try this,
= COUNT({<[YEARMONTH_SAL]= {"=[YEARMONTH]"}>} CONTACT_NUM)
For distinct count
= COUNT({<[YEARMONTH_SAL]= {"=[YEARMONTH]"}>} Distinct CONTACT_NUM)
Hope it helps,
-
Re: To use results of a selection list in a chart
Laurent ANKRI Jun 14, 2012 3:15 AM (in response to Mayil Vahanan Ramasamy )Hi
Thansks for your suggestion but it doesn't work
If I understand your expression return all the recors where YEARMONTH_SAL= YEARMONTH
What I want is the records from CV_TOU_CONTACTS_VW where YEARMONTH equals to the selection of the list box YEARMONTH_SAL
For example :
I have selected in the list Box YEARMONTH_SAL, the value '2012-1'
I want all the records from CV_TOU_CONTACTS_VW where YEARMONTH=2012-1 independently of the value of YEARMONTH_SAL
Thanks
-
-
Re: To use results of a selection list in a chart
Felim Shanaghy Jun 13, 2012 11:47 AM (in response to Laurent ANKRI)Your syntax is slightly wrong
COUNT({$<[YEARMONTH_SAL]={'[YEARMONTH]'}>} CONTACT_NUM)
Or
Sum(If (YearMonth=YearMonth_Sale,1,0))
-
Re: To use results of a selection list in a chart
Laurent ANKRI Jun 14, 2012 3:15 AM (in response to Felim Shanaghy )Hi
Thansks for your suggestion but it doesn't work
If I understand your expression return all the recors where YEARMONTH_SAL= YEARMONTH
What I want is the records from CV_TOU_CONTACTS_VW where YEARMONTH equals to the selection of the list box YEARMONTH_SAL
For example :
I have selected in the list Box YEARMONTH_SAL, the value '2012-1'
I want all the records from CV_TOU_CONTACTS_VW where YEARMONTH=2012-1 independently of the value of YEARMONTH_SAL
Thanks
-