Logic help for calculation =count(Date) in list box

[amit_saini]

Hi Folks,

Not sure if this is possible.

I'm having simple script like below:

LOAD User,

     Date,

     month(Date) as Month,

     year(Date) as Year

FROM

....

I have created below table in front end:

Is there any possibility that I can call count(Month) in a list box to get these numbers as a list????

Thanks,

AS

[sunny_talwar]

Try this:

=Aggr(Count(Month), Firstname, LastName)

[MayilVahanan]

Hi

May be try like this,

Add expression in the listbox

First Name

Exp: = Count(Month)

Or

Add like

=Aggr(Count(Month), [First Name])

[amit_saini]

Sorry Sunny , it's showing me '-'

I have tried something like below:

=aggr(count( Date),Lastname)

and this is working , but i believe this is count of Date not Month

Thanks,
AS

[Anonymous]

Yeah, you can......

Just use aggr() function in listbox expression intead of field....

Something like suggested by Sunny T

[amit_saini]

I have already tried this , not working.

PFA

Thanks,
AS

[Anonymous]

check this?

[amit_saini]

Balraj,

Actually I'm facing issue below:

Some cases it is working fine like below

and

in some cases not like below:

[MayilVahanan]

Hi'

Try like this

=(Aggr(Count(Month),  User))

[amit_saini · Accepted solution]

I think I got it. This is working

=Aggr(Count(Month), User)

Thanks,

AS